Excel F5 (Go to) — how to remove entries

Topic

New Reply

When I press F5, this box (below) appears. I have no idea how the first 4 items got in this box. I know they reference a cell or an expanse of cells. I didn’t purposely put them there. But, I must have done something for them to appear. Does anyone have any idea how one puts a cell reference in the Go To list, like the ones here?

How do I remove them? I don’t want them there.

I recognize all of the others, because I set them up in the Name Manager so they are OK. But, the first 4 — what action put them there? (I ask because I might want to purposely put a cell reference in this list one day) And how do I remove unwanted cell references from this Go to box??

Reply | Quote

Replies

Go to tab “Formulas”
There is “Name manager”

Delete unwanted entries in the list, that will appear.
Sorry for czech localisation, but you will understand

Dell Latitude 3420, Intel Core i7 @ 2.8 GHz, 16GB RAM, W10 22H2 Enterprise

HAL3000, AMD Athlon 200GE @ 3,4 GHz, 8GB RAM, Fedora 29

PRUSA i3 MK3S+

Reply | Quote

I don’t think I made my question clear. (No problem with the Czech, though)

Here is the F5 Go To box. There are two cell locations listed. They have no names, just the reference to row and column ($D$47, for example).

Here is the Name Manager dialogue box. There is nothing in it. If the cell locations listed in the F5 Go To box were listed here, I can see how I could do a deletion, but there is nothing in the Name Manager dialogue box.

I don’t want $D$47 or $B$44 to be in the F5 Go To box anymore. How do I get rid of them?

Both of these cell locations are nothing that I want to name and keep. They are simply one-time references to find my way around in a very long Excel file that I am editing. I want to save the file after editing, but I do not want the info in the F5 Go To box to be saved along with the document, since I needed those cell references only for this one edit.

Reply | Quote

I set them up in the Name Manager so they are OK.

I apologize for not understanding completely, you wrote it in your previous post
Interesting issue, it seems like you cant get rid of it.

There is an Application.PreviousSelections property that holds (up to) the last 4 cells used in a Goto command.

However, it seems there is no way to clear or delete the list, or do anytthing with it except query the addresses – so the only way to clear it is to close and re-open the workbook…

https://www.ozgrid.com/forum/index.php?thread/135256-clear-or-reset-goto-history/

https://techcommunity.microsoft.com/t5/excel/go-to-f5-how-to-delete-unwanted-entries-in-the-reference-list/m-p/1636631

Dell Latitude 3420, Intel Core i7 @ 2.8 GHz, 16GB RAM, W10 22H2 Enterprise

HAL3000, AMD Athlon 200GE @ 3,4 GHz, 8GB RAM, Fedora 29

PRUSA i3 MK3S+

Reply | Quote

Well, it looks like someone else has encountered this same problem. Closing and re-opening the workbook isn’t the solution here because I will lose the editing that I have done. It appears that I will have to name the locations, even though they are needed only for 1 editing session, which will allow me to delete them later.

Reply | Quote

Hi Folk,

Let’s say the very first cell is at the left top cell which is always [A1].

I always put the name of the tab here so I can use the Go To function for future reference.

Put curser on A1 [you should have the name of the tab already typed out here].  Hover right over the column A and click into the NAME OF BOX square.  Look when the name “NAME OF BOX” shows up when hovering over the A Column.  You will see it

Click inside that box.  These are your Go To names [another words links to other tabs or information].  Please make sure  name it is highlighted, usually in blue].  I always name it what the Tab is named but add the word “LINKED” after each one so that way I know I am the one that set up the GO TO link]

Example:  My Name of Tab is:   A1 Tab Sheet

Type exactly what I put here:       arr_A1TabSheetLinked

So now this will show in your [Tool bar @ top – Formula – Name Manager].  You can also edit or delete others.  Be careful though, you can lose formulas and GO TO’s that connect to other sheets.

On my main sheet, I have my morning things to do and check.  I have 76 tabs.  So on my main A1 Tab Sheet, I have a list of all my tabs with their names and all I have to do is click the cell and it takes me right to the page of the tab [Make sure you have named that Sheet [TAB] too.   These are hyperlinks   [Right click and bottom one is Hyperlink.

Ok I have to go.

Hope you can understand.  Leave questions if you like.

Thanks

Cheryl

Reply | Quote

I don’t have Excel. In some applications that I have I can just Select (left-click) an entry, and tap the Delete key.

Reply | Quote

PaulK wrote:

I don’t have Excel. In some applications that I have I can just Select (left-click) an entry, and tap the Delete key.

That doesn’t work. I’ve tried that and also have tried Backspace. No dice.

Reply | Quote