Excel Named Range Advanced Features

1. You can set Non-contiguous Named Ranges by holding down the CTRL key while you highlight the cells you want to name.

2. Set Dynamic Named Ranges that update automatically as your data grows using the OFFSET function.

3. Shortcut to Create Named Ranges from a table of data. If you have your data laid out in columns or rows with headers Excel can interpret this and set up Named Ranges for you automatically. Simply highlight all of your data and click Create from Selection on Define Names group as you can see below or press CRTL+SHIFT+F3 and the following dialog box will open.

Excel will ask you if you want the names created from values in the Top Row, Left Column, Bottom Row or Right Column. Simply tick your choice(s) and click ok. You now have Named Ranges automatically set up using the names of your Column or Row headers.