In two cases of references between worksheets, the formatting from the original cell does not appear in the cell that it is referenced to. Case 1: Worksheet...

Hoping someone can tell me if my understanding of custom views is correct. I have been given a spreadsheet of around 100 rows. The rows all contain a dollar...

I have created an workbook with Excel and put a photo on the first page. when I publish the workbook as an web page (interactivity) my photo is missing....

I have created an workbook with Excel and put a photo on the first page. when I publish the workbook as an web page (interactivity) my photo is missing....

I want the cell format (meaning color of the cell) to change based upon the text entered. I have used up the conditioal formatting. It only allows three...

I have added a macro in my last reply to your 7 Jan message Bernard

Using Excel 2007. ======= Just started a new job with an electrical contractor. They have a paper-based inventory & pricing system. I want to put this in...

Is there a way to hide the "#value!" so it does not show in the cell?

FYI, the MS Discussion Groups web interface is not displaying postings again. It appears to be accepting and propagating postings; they are simply not...

Hello I have a number (usually 1 decimal place, sometimes an integer) which I want to show with its units (in this case kWh), eg 3250.6 kWh. I know I can...

Helllo, I have a spreadsheet (rather a big one) which shows an error (triangle in the corner of the cell) in all the cells of a single column. I understand...

I have a record of payments on a loan for 2008 and 2009. How do I copy the heading information (make a new form) for 2010?

I have data in col B row 1 to 10: I have a chart of this worksheet showing col B row 1 to 1000 Here is the trouble:The chart shows the data in row 1 to 10 but...

Where is the Exel 2003 HOME key?

I have a spreadsheet with data in col b starting at row 1 and continuing down to row 10. I want to have a chart depict the values in row 1 to 100 as I will...

I received a template by email. The template is in Excel 2007. My Excel is 2003. Everytime i enter data the data under so a conversion process. How can i...

Is it possible to create a calendar that has a function to list recurring meetings, functions, etc.?

I exported a few hundred contacts from my Windows Live Mail as CSV file and opened it in Excel 2002. Of course, I can easily print this spreadsheet as it...

Hi there, For whatever reason when our system compiles data into Excel 2003 it creates a worksheet that looks like this (for example): Purple Purple ...

I have Office 2007 and everytime I open an existing excel file or open a new excel workbook it goes into the compatability mode, it will say Book 1...