Formatting: A detail which makes the response to the user "not exact/unique": Take the following path in any cell: Format / Number / Date / Type Say you have...

1. In Excel 98 I could keep things in icon view and they would remain alphabetical in recent documents. Now I can't seem to lock this view in. Anyone know...

Microsoft Excell should have an option to set up all spreadsheets with the same header/footer throughout an organization. That way every spreadsheet in a...

Whenever I use the Wizard to modify a Pivot Table the toolbar is undocked and is floated over my worksheet. I then have to re-dock the toolbar like...

Some of my excel worksheet become corrupts. Actually, I'm not sure is it corrupt or not, because the excel file can opened normally. However some of the...

In regional settings I have short date = yyyy-MM-dd. When I type any date for example 2005-05-18 excel change it to 18-05-05. How can I fix this?

For some reason, on just a a few of our shared Excel files, when saved by the client Excel creates a temp file in the directory. It has created somewhere near...

I do not have the button in Tools - what should I do ?

I am using Excel to build a catalog of 100 items that can be sorted. In one of the columns, I want to use a humbnail of the JPG file associated with the item...

Is there are way of making permanent changes to the font size used by default in a comment? 8pt is too small and editing every comment to change from 8 to...

I am using Excels "built-in" data entry form to input elapsed time which is formatted as :mm:ss in the bound cell. Entries are captured correctly...

does anyone know where i can get an invoice with discount and vat calculation on it for accountancy

Where is it stored in Excel?

Microsoft Excel 2000 - How can I prevent Excel 2000 from inserting hyperlinks into my spreadsheets? I would like to customize Excel to never do this to any of...

How do I set Excel so that when I start it, it does not create a new/blank work-book? (I want to just use the 'recent files' menu to pick something most of...

Hi! In Excel2003 if I click on Tools, Option, Color tab, I have the option to modify the colors in the palette. I was under the impression that this user...

Enter a numberin cell eg 56. It automatically becomes 0.56

How do you create a chained select list in excel? Chained Selects lets you "chain" multiple form select lists together so that the selection in a "parent"...