Ranges within tables

Resolved · Low Priority · Version 2007

Thu 5 Dec 2013, 16:35 Delegate Kalpna said...

Kalpna has attended:
Excel Advanced course

Ranges within tables

autoincrease rage that gets picked up on pivot table or name range.

Fri 6 Dec 2013, 12:38 Trainer Gary said...

RE: Ranges within tables

Hi Kalpna

Thanks for getting in touch. The best way to do this is convert your range into a Table.

Click inside your source data and then go to Home > Format as Table. If you build a PivotTable off this Table your range will increase as more rows are added. Next time you Refresh you will see the appended data included in your PivotTable.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Fri 13 Dec 2013: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Manually rotating a 3D chart

To manually rotate a 3D chart;
Select the chart (edit mode) and click on one corner of the chart display area. A selection border will appear, using the left mouse button on one of the chart's "corners" (mouse pointer changes to a cross) drag the image which becomes a line representation of the chart (as you begin to drag) and rotate the chart to a view of your choice.
If you dont get it right first time, dont worry, the manoeuver is a little bit tricky.

View all Excel hints and tips