Microsoft Excel - Navigate Quickly Using the Name Box

The Name Box in Excel can be used to quickly navigate to different cells in a spreadsheet. Although not necessary for worksheets that use only a few columns and rows, but for larger worksheets, it can be useful to have an easy ways of jumping from one area to the next.

Follow these steps:

1. Click on cell you would like to “name”. In Name Box which is located above Column A type in the “name” you want to call that cell. For example, Total Sum, because in your large spreadsheet you want to be able to go back to Total Sum frequently to see that number.

2. Press the ENTER key on the keyboard.

3. That cell is now “named” Total Sum. To navigate to that cell, use the drop down menu in the Name Box (above Column A); you will see all the cells that you have named.

It’s always great to find new ways to work as efficiently as possible.