pivot table shortcut key

[Raja]

Is there a shortcut key assigned to creating a pivot table?

Example the chart can be created by selecting the data and pressing F11 key
which takes all the default settings and creates a new column chart in a new
sheet!!

Is there a simply key combination for creating a Pivot Table? any other
helpful tip or trick related to Pivot tables will be highly appreciated!!

Cheers

Raja

 

[Marcelo]

you can customize your toolbar including a pivot table icon.
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Raja" escreveu:

 

[FSt1]

hi
see this site.
shows all keyboard short cuts for all ms products from 2000 to 2007.
http://www.microsoft.com/enable/products/keyboard.aspx

the only thing i saw relating to pivot tables was how to select the table.
Ctrl+shift+*
but hey.....i might have missed something.

Regards
FSt1

 

[Roger Govier]

Hi

When you use the F11 key to create a chart, the PT has already been created
and you have chosen which fields are to be Page, Row or Column Fields, and
which fields represent the data.
As none of those are set before the Pivot table is created, it would not be
possible to have an icon or a shortcut key which achieves what you want.

In Excel 2003 and lower, you can just place your cursor in cell
A1>Data>Pivot Table>Finish and this will get you to the skeleton PT on a new
sheet ready to allocate the fields.

If you wanted that as a macro, to add to an icon on your toolbar it would be
something like

Sub CreatePivot()
Range("A1").Select
ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
"Sheet1!R1C1:R3C3").CreatePivotTable TableDestination:="",
TableName:= _
"PivotTable1", DefaultVersion:=xlPivotTableVersion10
ActiveSheet.PivotTableWizard TableDestination:=ActiveSheet.Cells(3, 1)
ActiveSheet.Cells(3, 1).Select

End Sub

To use the macro, copy the above
Alt+F11 to invoke the VB Editor
Insert>Module
Paste code into white pane that appears
Alt+F11 to go back to Excel

Alt+F8 (or Tools>Macros) >select CreatePivot>Run

Or, allocate the macro to an icon added to your Toolbar.