JoiWiki » Developer » MS Office » Excel Tips and Tricks » Excel Named Range Tricks Excel Named Range Tricks

Excel Named Range Tricks

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?!

















Created by JBaker. Last Modification: Monday December 10, 2018 12:33:26 GMT by JBaker.