"Go To" function

elaw74

New Member
Joined
Nov 3, 2002
Messages
2
Hi,

I had a question posed to me and try as I might I was not able to find a way to do it so I was hoping that someone here might know the answer. I am trying to find a way to make the "go to" function bring the named cell to top left corner instead of the lower right corner. Does anyone know of a way to do this? Thank you in advance for any help you may be able to offer.
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

elaw74

New Member
Joined
Nov 3, 2002
Messages
2
Sure, if you hit the F5 key it brings up a go to function that allows you to go directly to a cell that you named. Well when you do this instead of bringing that cell to upper left corner of the viewable area it brings the cell to the lower right of the viewable area. I know this is a pretty trivial problem but this person asked so I figured I would try and find out if it could be changed. Thank you.
This message was edited by elaw74 on 2002-11-04 14:42
 

phantom1975

MrExcel MVP
Joined
Jun 3, 2002
Messages
3,962
AHA! I thought you were referring to VB code GOTO function. I'm afraid I don't know that answer to that one.
 

Forum statistics

Threads
1,143,739
Messages
5,720,578
Members
422,292
Latest member
Bernd0501

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top