If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
excel 2007 pivot table wizard
Good Afternoon.
Thanks in advance for your help. I am being forced to go to 2007 since the work environment has updated their software packages and I am sure that I will be pleased with the latest and greatest after I find all of the buttons that I have been using with 2003. I am attempting to use the Pivot table in 07 and am having difficulty in finding the wizard similar to the 03 version. The 03 would allow the "Floating toolbar" to have a dropdown and select the wizard to "reconfigure" the layout if the user wanted. Also the "page" function on the wizard was a great help to me and I can't find it either. Thanks so much for you help, my grey matter is getting a bit sluggish as I get older, it still beats the alternative. cil |
#2
|
|||
|
|||
excel 2007 pivot table wizard
The 'old' PivotTable wizard still exists in Excel 2007 but to use it you will
either need to customise the Quick Access Toolbar to add the button 'PivotTable and PivotChart Wizard' from the 'Commands Not in Ribbon' or 'All Commands' category, or alternatively you can use the Excel 2003 keyboard shortcut sequence Alt-D-P to launch the wizard. Source: http://www.accountingweb.co.uk/cgi-b...rmat=%25o-%25B "CIL" wrote: Good Afternoon. Thanks in advance for your help. I am being forced to go to 2007 since the work environment has updated their software packages and I am sure that I will be pleased with the latest and greatest after I find all of the buttons that I have been using with 2003. I am attempting to use the Pivot table in 07 and am having difficulty in finding the wizard similar to the 03 version. The 03 would allow the "Floating toolbar" to have a dropdown and select the wizard to "reconfigure" the layout if the user wanted. Also the "page" function on the wizard was a great help to me and I can't find it either. Thanks so much for you help, my grey matter is getting a bit sluggish as I get older, it still beats the alternative. cil |
#3
|
|||
|
|||
excel 2007 pivot table wizard
Thank You Sheeloo.
"Sheeloo" wrote in message ... The 'old' PivotTable wizard still exists in Excel 2007 but to use it you will either need to customise the Quick Access Toolbar to add the button 'PivotTable and PivotChart Wizard' from the 'Commands Not in Ribbon' or 'All Commands' category, or alternatively you can use the Excel 2003 keyboard shortcut sequence Alt-D-P to launch the wizard. Source: http://www.accountingweb.co.uk/cgi-b...rmat=%25o-%25B "CIL" wrote: Good Afternoon. Thanks in advance for your help. I am being forced to go to 2007 since the work environment has updated their software packages and I am sure that I will be pleased with the latest and greatest after I find all of the buttons that I have been using with 2003. I am attempting to use the Pivot table in 07 and am having difficulty in finding the wizard similar to the 03 version. The 03 would allow the "Floating toolbar" to have a dropdown and select the wizard to "reconfigure" the layout if the user wanted. Also the "page" function on the wizard was a great help to me and I can't find it either. Thanks so much for you help, my grey matter is getting a bit sluggish as I get older, it still beats the alternative. cil |
Thread Tools | |
Display Modes | |
|
|