dynamic ranges excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Dynamic Ranges in Excel

resolvedResolved · Low Priority · Version 2010

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

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 tip:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

View all Excel hints and tips


Server loaded in 0.09 secs.