pivot table shortcut key

R

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
 
M

Marcelo

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



"Raja" escreveu:
 
R

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top