I am doing an excel spreadsheet at work. The column I need to total seems to have a fault, and autosum doesn't work. What can I do?

Hi All, Is there a way to compare contents between two sheets, and use conditional formatting to highlight the difference without using Macro? I am looking...

Using XL 2003, I want to import data from another program. I can do so with the Text to Columns feature, but, the program uses exclamation points and a comma...

I have been using a simple red, yellow, green ICON Set to evaluate a field but the wrong icon comes up when the value matches the formula...

Hi Guys I have a date entry form. One box requires a date. I have several users using the form, each types the date in a different way. I would like a...

When I open the Excel file from my vendor using Excel 2003, I get a message box that says "Errors were detected in 'ExcelName.xls', but Microsoft Office...

Have I missed something here? =IF(E130,"early",E130,"late") Cheers!!

Hi everybody, I created an evaluation form some time ago in Excel 2003. Originally it was sent out to people after they had completed their training. It went...

I'm heavy on the keyboard shortcuts, and I hate having to switch over to the mouse to align the text inside my cells? Does anyone know if there are shortcut...

Hello, I want the footer in my print-out to pull some information from my workbook (ideally from a different sheet) Is this possible? Thanks M

I want to see if the employee is a male or female from the ID number? ID number - 751105 0 931087 The SEVENTH number will tell you if the employee is a male...

Some of my users complains about problems opening Excel documents. About 2 sec. after they open a document it close automatically. I have found out that the...

We have excel workbooks with sheets that contain hyperlinks to other sheets within the workbook. We have these workbooks saved to a WSS 3.0 site. When using...

I need a formula to calculate the following information please: I will have someone enter a time (ex 6:31) in cell C3. If the time matches one of the times...

I have read all the other threads on this subject and they work fine for me untill I need to cross midnight and the value is the time subtracted from 24 here...

I am very new with excel and I am putting together a worksheet that has a column consisting of two primary names. I would like to format the entire column...

I created several columns (fields) in my excel table, one of the column is named as "SIZE". Could you please advice if "SIZE" is one of the reserved words...

This bombs at the end - with a no cells were found message. My objective is to copy a file to another file and delete the blank rows - where company is...

I have the following that I would like to do. There are two separate worksheets within a workbook: worksheet 1 and worksheet2. On worksheet2 I would like...

Is it possible to have a range of cells or an object float while scrolling.