Go Back to Previous Locations in Excel

In Excel, you can create named ranges, and go to those ranges by selecting a name from the Name Box.

namedrangeselect

In addition to those permanent names, you can also store up to 4 temporary locations, and to back to those locations quickly. This is handy if you’re making updates to a big workbook, and want to switch between a couple of sheets quickly, without lots of scrolling.

Temporarily Store a Location

Here are the steps for storing a location:

  1. Select a cell on the worksheet
  2. Click in the Name Box, which is to the left of the Formula Bar
  3. Press the Enter key, to temporarily store that location.

namebox01

Go Back to a Stored Location

When you want to return to one of the 4 temporarily stored locations:

  1. To open the Go To dialog box, press the F5 key, or press Ctrl + G
  2. If the location that you want is in the Reference box, press the Enter key, to go to that cell
  3. To go to another location in the list, double-click on that location in the list.

gotolist

It’s Only Temporary

When you’re using this technique, remember that the locations are only stored temporarily. When you close the file and reopen it, you will have to store a new set of temporary locations. If you need something permanent, you can create named ranges instead.

You’ll find more worksheet tips on my Contextures website: Excel Worksheet Tips

Video: Go Back to Previous Locations

To see the steps for returning to a previous location, please watch this short video.

__

_________________________

You may also like...

5 Responses

  1. Hi Debra,

    I never knew this!
    If you need a more permanent list which lasts longer, download my GoBack tool from http://www.jkp-ads.com/download.asp

  2. Ankit Mac says:

    Nice tutorial Debra, I didn’t knew that Excel stores these named ranges temporarily.
    Thanks for sharing this nice tip.

  3. Edgar says:

    Great! It help me a lot! Thanks very much…

  4. John says:

    Debra I had seen this in the dialog but never knew the significance. Really handy tip. This newsletter is amazing, always interesting stuff, thank you!

Leave a Reply to Jan Karel Pieterse Cancel reply

Your email address will not be published. Required fields are marked *