Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Ranges & Pivot Tables

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Ranges & Pivot Tables

Resolved · Medium Priority · Version 2003

Reply Fri 13 Mar 2009, 16:54Delegate Dagna said...

Dagna has attended:
Excel Advanced course

Ranges & Pivot Tables

How do i create dynamic named ranges?

For upcoming training course dates see: Pricing & availability

Reply Tue 17 Mar 2009, 13:37Trainer Rajeev said...

RE: Ranges & Pivot Tables

Dear Dagna

Thank you for attending Excel Advanced course!! I hope you enjoyed the course and benefited from it.

Please refer to the following link to help you create a dynamic named range. The advantage of dynamic named range is that when any data is added or deleted from the existing range it automatically adjusts itself.

http://support.microsoft.com/kb/830287

Please refer to the uploaded file that I downloaded from one of the websites. It has some examples of the dynamic named ranges. Please feel free to experiment by adding/Deleting extra rows/columns to see how the results vary.

You can use CTRL +Z (Undo) to get back to the original.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Attached files...

Dynamic named Range example.XLS

Reply Tue 17 Mar 2009, 13:47Trainer Rajeev said...

RE: Ranges & Pivot Tables

Dear Dagna

Sorry in addition to my pervious post to have dynamic named ranges for your Pivot tables you can refer to the following links that provide you easy step by step instructions:

http://www.contextures.com/xlPivot01.html

http://msexcelraj.wordpress.com/2007/07/01/how-to-create-a-dynamic-pivot-table-in-ms-excel/

The above links are a good source to understanding dynamic ranges in Pivot table!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Tue 24 Mar 2009: Automatically marked as resolved.

Excel articles

· Customized Financial Excel Courses in London
· Summing Up Scenarios With Excel
· Do You Need To Run Excel 2007 In Compatibility Mode?
· How To Create A Real Line Graph In Excel 2010 Rather Than A Line Chart
· Excel in the Home Office

Please browse our web site to find out more about
excel vba training and other Microsoft training courses.

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips