When opening an existing file, the default is to view all file types. However, in Excel it defautls to .xls files. How do I change the Excel default to view...

Hi all, I downloaded a budget spreadsheet form the MS site but all the values, totals and formulae are in $ not £’s there an easy way to convert them....

When I try to start excel, I'm told that I need to insert my Office 2000 Premium CD in order to find a file named data1.ms1. Unfortunately, I cannot find my...

I just came out of a Mac and when I protected a spreadsheet I could hit Enter to move to the next unprotected cell. In the PC version, enter moves down a cell....

Have used Excel, however not an expert. My document list was in alphabetical order, however within the last week, it is not. Don't know what I did to get in a...

I am looking for something that will find the last cell of data in a column, here is what I want to do the function I have is =if(a1=0,0,(b1-$cS10)*d1) C10...

this is for excel 2000 excel crashed while doing some vba code testing now when re-opening the sheet where crash occurred i get the file is already open by...

Hi, I want to use sumif in the following way : SUMIF(purchases!O18:purchases!O500,"=b21",purchases! Q18:purchases!Q500) and not...

I'm getting stuck on something really basic. I want to compare the sum of two cells with the value of one cell multiplied and, if greater, turn the cell...

I have a constant problem. Whenever I install Office 2003 it claims to have installed all of the programs, but I can't find anything to indicate that Excel has...

I would like to hide a sheet so that it is only visible to certain users. I do not think the Format, Sheet, Hide command is not secure enough. I would like...

How do I set up repeating data in specified blocks from page to page without retyping it on each and every page?

I have recently had to reinstall windows xp (home-sp2) due to corrupt registery. At this time I also noted that none of my current MS Office (Excel or Word)...

when tracing a cell's dependents, i get a beep and an error message (that needs to be clicked before continuing). How can i turn the message off?

The policy to run only allowed applications is ignored when the right-click context menu option to Export to Microsoft Excel in selected in Internet Explorer. ...

I want to calculate a running balance for a check register in Excel. How do I do that without having to enter the formula each time? Can I have the...

The bottom scroll bar is missing from my Excel spreadsheets.

I regularly need to insert new worksheets into a workbook, based on the format of previous sheets. I do this by inserting a new blank worksheet, then copying...

To be more specific, if I already have files opened in Excel, and I select an Excel file via an Internet Explorer hyperlink, it ALWAYS causes all other open...

We would like to have part of a spreadsheet with conditional formatting pasted into a new document that shows the data the way it was conditionally formatted...