Master your skills in Microsoft Excel with these helpful shortcuts that lets you navigate between cells, spreadsheets and files. Get Excel-lent work done with more excel shortcuts here
Create a Dynamic Named Range
- Named range is the name given to a data range, and it can be used to simplify formulas. To create a typical Name Range, select the range, click on the ‘Name Box’ (top left, where the cell name appears), enter the name of the range and hit ENTER.
- Unlike a normal Named Range, a Dynamic Named Range will expand automatically when values are added. Learn how to do this Excel magic trick in this video!
For more shortcuts on productivity tools like Microsoft Excel, subscribe to TheBizJuice.
Found this article useful? Share it with your fellow entrepreneurs.