So named ranges are great for many reasons - I'll go into these at some point, here are some tricks:
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?!