Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Table

Pivot Table

ResolvedVersion 2007

Mon 17 Nov 2008, 15:02 Delegate Fabiana said...

Fabiana has attended:
Excel Advanced course

Pivot Table

After creating a pivot table how can I save the format as a template for the next tables?

Wed 24 Dec 2008, 10:37 Trainer Mark said...

RE: Pivot Table

Hi Fabiana

Thanks for your post - sorry for the late reply

It is possible to do this process to do this you can follow the steps below:
Create the format of the pivot table then from the pivot table tools tab from the table designs go to the drop down list labelled more then at the bottom of the list choose save current selection

Please let me know if this helps you

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Tue 30 Dec 2008: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Filtering Data in an Excel 2010 Worksheet

When you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter.

You will now see arrows in the top row of all the columns. If you click on an arrow, it will give you some filtering options so you can sort your data into ''Smallest to Largest'' or ''Oldest to Newest'' and so on..

To turn off the filtering, go back to the Home tab and click the Filter button again.

View all Excel hints and tips

Pivot Table

Pivot Table

RE: Pivot Table

Excel articles

Excel tip:

Filtering Data in an Excel 2010 Worksheet