Named Ranges

 

So named ranges are great for many reasons - I'll go into these at some point, here are some tricks:

 

Multiple named ranges at once

If you've got a few columns (or rows infact), one with the names of ranges that you'd like to assign and one that you'd like the ranges assigned to select both, click Ctrl+Shift+F3

• Select both columns
• Click Ctrl+Shift+F3
• select where the names should be pulled from (which column/row etc..)
• click ok!

now you should be left with a load of named ranges with names pulled from the designated column (or row) - hasn't that saved a load of manual input?!