Is there a way to format cells in Excell to automatically capitalize the first letter of text in a cell?

I have formatted a column to show fractions, but I want that column to display even denominators, highest of which is 32nds. Sometimes, I get 5ths, 31s,...

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

Have just upgrade to 2003 and alll my old .xls files now appear as $s I choose UK ~ Striling when upgrading/install 2003 I'd rather not have to open & convert...

When I go to Page Setup Sheet the Print headings options are greyed out so I cannot select any rows or culmns for this. The document spans 8 pages. I have set...

I often accidentally print entire sheet instead of just the first page. I only the first page to ever be printed. Is there a way to block the rest of the...

Excel 2003 is obviously complaining about some file named "C:\Documents and Settings\mxlpltx\My Documents\xxx.xls" that isn't in quotes but I can't seem to...

In excel 2002 how do I get into the default excel book template to uncheck the zero box and save it so that I dont have to go to options each time I open a new...

We have a number of spreadsheets that retrieve data from an access database that, in turn, uses linked tables to our accounting system via ODBC. We have a...

I start Excel then load several files. Each file I load put an Xcel icon in the desktop toolbar. How do I stop this. I would expect this behavior when I...

If i open an Excel file by double clicking it and then open another by double clicking it too, both excel files end up in the same window by default. I want...

My Excel has freaked out. All my excel files open up into some strange default view setting where only the tool bar across the top is displayed. The actual...

I am running Office Proff. 2000 and can't use the "open with" function for excel or word. The rest of the programs appear in my choices but not these. Mersion...

I forgot how to change the cursor speed, in Excel, anyone know how to speed up so as to scroll faster across the sheet using the arrow keys?

I had to reinstall windows xp yesterday, now none of my office programs work. They ask me to run setup, but I can't find the file on my hard drive....

Opening Excel from Start Menu or opening excel file generates following message: "Excel.exe has generated errors and will be closed by Windows. You will need...

Clean out temp files, temp internet file (include offline content), history, see what all is running in the background (CAD to get to task...

I have results from surveys we sent out and I need to make a database of the results. I am more familiar with Excel than Access. We have questions that the...

Having Personal.xls *is* handy. But when starting a "new" workbook, Excel *assumes* I mean "Personal.xls" and opens "it". If I save it as my new book, it...