Editing the name box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I entered a name in the name box for the top left cell of a form but when I
clicked on the name, the cell showed up at the bottom right of the screen. I
was successful in creating a name for a different form (the starting cell
shows up at the top left of the screen), but I can't get the first form's
starting cell out of the bottom of the screen. Now I have four different
names for the same form in the name box.

How do I clear the name box of useless names? How do I get the starting
cell at the top left of the screen?
 
Insert/Name/Define, then find the name, then click Delete.
You can't ensure the named range will go to the top left of the screen,
unless you name a much larger range which shares the same top left cell,
then go to that range first. For example, if the name you give cell F22 is
"Bob", using F5 key to go to Bob will not bring it to the top left. If you
name Range F22:Z300 BigBob and use the F5 key to go to THAT range (BigBob),
then F22 will be the top left of the screen. You can then use
shift/backspace to select the active cell only. (or just click F22).
HTH
Bob Umlas
Excel MVP
 
Thank you. All is better now.

Bob Umlas said:
Insert/Name/Define, then find the name, then click Delete.
You can't ensure the named range will go to the top left of the screen,
unless you name a much larger range which shares the same top left cell,
then go to that range first. For example, if the name you give cell F22 is
"Bob", using F5 key to go to Bob will not bring it to the top left. If you
name Range F22:Z300 BigBob and use the F5 key to go to THAT range (BigBob),
then F22 will be the top left of the screen. You can then use
shift/backspace to select the active cell only. (or just click F22).
HTH
Bob Umlas
Excel MVP
Click to expand...
 
Back
Top