Go Back to Previous Locations in Excel

Go Back to Previous Locations

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

select name from Name Box
select name from Name Box

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.
Click in the Name Box
Click in the Name Box

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.
Go To dialog box
Go To dialog box

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.

_________________________

0 thoughts on “Go Back to Previous Locations in Excel”

  1. 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

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.