When I open Excel, how can I get the same file to open each time in "files of type"? "ALL MICROSOFT EXCELL FILES" is the default and I would like to have...

hi i hv an excel sheet with more than 60,000 rows of data (abt 8 columns) i need to find one particular number in all that data. i use ctrl-f to search for...

I received a warning message while attempting to cut a group of cells from one sheet to move them to another sheet. "warning - fixed objects will move" with...

I have some Excel files in which "Format Cells" is not working. I cannot bring up the format cell box either through Ctrl-1, the task bar, or right-clicking...

Somehow I've broken my format tool bar -- the one where you can click buttons to force a cell to formats for "$", "%", ",", etc. Everything works normally...

i get the above error message when i try to change a source link. what does it mean and how do i correct it? thanks

Hi, I have a spreadsheet I want others to use. I use high resolution on my laptop and can see the entire at once. But others use lessor resolutions and have...

HI We are facing a consistant difference in real time behavior between Excel 2003 behaviour and Excel 2000 behaviour in the usage ot the...

I'm trying to change the color of text in an Excel spreadsheet. Can anyone help me with this or can this be done?

A 1 10 2 17 Want formula for cell b1 that will look at A1, if = 14, then A1*.5 . If A1 is =15, then it would multiply the first 14*.5, then from 15 on...

I have a number of simple two column sheets, one column contains dates. Basically each sheet is an employee, and the items list the date and notes for any "one...

xl2000—Totaling time worked at each of three stores for a two-week pay period. What I have is Columns C, D, E, F, G, H, & I, are week one. Columns M, N, O,...

I need to figure out a formula for the following senario: I have three columns; Column "A" has is a list of "license" numbers; Column B Would be a name...

If A2=100, or 200 or 300 or 400 or 500 or 820, Then let C2=B2*2 How can I write this formula? Thanks.

Here is the starting of my formula. =IF(I12I69,I69.I12) My problem is that if I69 is empty I want it to return I12. How can I get it to do...

Hi, I have a spreadsheet that asks "yes" or "no" questions. I want to assign a value of 1 to all yes reponses and a value of 0 for all no responses. I...

I need help in writing a "IF" statement in a pivot table. My data consists of sale orders numbers that may have several line items - I am trying to do a count...

How do you create the formula for the following: If cell X has a certain character (1,2,3,4,5,6) then I want cell Y to be populated with a determiend value...

"Input sheet" that distributes data to other worksheets. I wish to create an "input template" that based on the name in a "customer" cell it should place the...