Forum home » Delegate support and help forum » Microsoft Excel Training and help » Dynamic Ranges in Excel

	98.1 % recommend us
	More live stats...

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

Training information:

Dynamic Ranges in Excel

Resolved · Low Priority · Version 2010

Reply Thu 17 Nov 2011, 10:22Delegate Scott said...

Scott has attended:
Excel Advanced course
Excel Advanced course

Dynamic Ranges in Excel

During our training, Dynamic Ranges were mentioned and how these can be used in Named Ranges. Please can you explain how these work
Thanks
Scott

For upcoming training course dates see: Pricing & availability

Reply Fri 18 Nov 2011, 06:46Trainer Anthony said...

RE: Dynamic Ranges in Excel

Hi Scott, thanks for your query. There's a good walkthrough of dynamic named ranges here:

http://www.ozgrid.com/Excel/DynamicRanges.htm

Hope this helps,

Anthony

Thu 24 Nov 2011: Automatically marked as resolved.

Excel articles

· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· The Mysteries Of Excel Explained
· How To Use The Research Functionality In Excel 2010
· Organisation At Your Fingertips - Take Control Of Your Life With Excel
· What's In A Number? Make Figures Mean More Via Excel

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

Excel tip:

Switch on smart tags – Excel 2007

In order to use smart tags, make sure they are turned on, to do this:
1. Click on ‘Microsoft Office‘ button and then click on ‘Excel Options‘.
2. Click on ‘Proofing‘ category and then click on ‘Auto Correct Options‘.
3. In the ‘Auto Correct‘ dialogue box appears, click the ‘Smart Tags‘ Tab.
4. Tick the boxes, next to the Smart Tags you wish to use in Excel

View all Excel hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy