General

Calculated percentage field in a pivot table
This is a part of the pivot table Year Class average of subtot sum of accounts 2002 1 126631 18759 2 126631 19103 3 126631 59277 4 126631 24416 5 126631 5076 How can I insert a field to get the percentage? I have tried ... 2 Jul 2008 05:44

Autofill in 2007
Hi I am trying to showe someone Autofill using Office 2007. When I run my version of Excel i have 8 options including Fill Days, Weeks weekdays years, but my collague doesn't have those options on his version of Excel 2007. can anyone advise me why? thanks Alex ... 3 Jul 2008 18:41

worksheet help
Dear Support How can i access the options in the sheet menu ( like renaming the sheet , delete, changing the tab colour ... ) by keyboard only as it can save a lot of time for me. -- With Thanks Regards Rajesh Chandra ... 2 Jul 2008 08:48

problem selecting only one cell at a time in excel 07
when selecting some cells, it is difficult to select only the single cell. sometimes I get two across or even 2x5 has occured. Also, it seems not to be consistant. I may zoom in and out then it may work just fine. ... 2 Jul 2008 04:43

Converting values which are in Numeric format to word format
I have a sum total of figures in numeric value eg: $5000.00 i want the same in words format ie. USD Five Thousand Only. How can i do the same using formula? ... 2 Jul 2008 04:43

pivot table creation procedures
I DON'T KNOW ABOUT PIOT TABLE PLZ. YOU CAN TELL ME MORE INFO ABOUT PIVOT TABLE PLZ. I WILL REQUEST YOU PLZ. SOLVE MY PROBLEM ... 2 Jul 2008 04:43

formula help
i have arange of values from say h1 to h34 and i need to find the values under a certain amount and give me the names ofr these values from column a. if you understand this explanation how would i do this? ... 2 Jul 2008 05:44

worksheet help
Dear Support How can i access the options in the sheet menu ( like renaming the sheet , delete, changing the tab colour ... ) by keyboard only as it can save a lot of time for me. -- With Thanks Regards Rajesh Chandra ... 2 Jul 2008 01:40

Automatic Calculations to Default
Hi! I'm trying to find out how to change the options in my Excel to automatically update caluations. At the moment they are always on manual every time I open a new workbook! I'm using Excel 2003, if someone could help that would be great! THANKS! ... 2 Jul 2008 03:42

reset a workbook each month saving a copy and using totals to rest
Ecel 2007. I have created a set of spreadsheets which I want to use on a monthly rolling basis. I would like to know how to save a copy of the sheets at the end of a calandar month and to reset the sheet entries for the start of the new month using the totals from the previous month as the start figures for the... 2 Jul 2008 01:40