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

Yes, there is a shortcut key assigned to creating a pivot table in Microsoft Excel. Here are the steps to create a pivot table using the shortcut key:

1. Select the data range that you want to use for the pivot table.
2. Press the shortcut key "Alt + N + V" in sequence.
3. This will open the "Create PivotTable" dialog box.
4. In the dialog box, select the range of data that you want to use for the pivot table.
5. Choose where you want to place the pivot table (either in a new worksheet or in an existing worksheet).
6. Click "OK" to create the pivot table.

In addition to the shortcut key, here are some other helpful tips and tricks related to pivot tables:

1. Use the "PivotTable Fields" pane to easily add or remove fields from your pivot table.
2. Use the "Value Field Settings" dialog box to change the summary calculation for a field (such as sum, average, count, etc.).
3. Use the "PivotTable Options" dialog box to change the layout and formatting of your pivot table.
4. Use the "Refresh" button to update your pivot table with new data.
5. Use the "Slicer" feature to filter your pivot table by specific criteria.

I hope these tips and tricks help you get the most out of your pivot tables!

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



"Raja" escreveu:

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

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

"Raja" wrote:

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

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
A1DataPivot TableFinish 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:=xlDatab ase, 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
InsertModule
Paste code into white pane that appears
Alt+F11 to go back to Excel

Alt+F8 (or ToolsMacros) select CreatePivotRun

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

--
Regards
Roger Govier

"Raja" wrote in message
...
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