ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Shortcut to go a certain cell (https://www.excelbanter.com/excel-discussion-misc-queries/120146-shortcut-go-certain-cell.html)

Art

Shortcut to go a certain cell
 
Is there a way to make a shortcut to a go to a certain cell. lets say I want
to jump to cell D45 and I'm currently on cell A4, is there a way to jump
there with a shortcut, like if in cell D45 sais Freezer, and I type "F", it
should jump to that cell?

JMB

Shortcut to go a certain cell
 
Hit Cntrl+G and type D45 in the reference box.

"art" wrote:

Is there a way to make a shortcut to a go to a certain cell. lets say I want
to jump to cell D45 and I'm currently on cell A4, is there a way to jump
there with a shortcut, like if in cell D45 sais Freezer, and I type "F", it
should jump to that cell?


Art

Shortcut to go a certain cell
 
Thanks. Do you have any other shortcuts, or a faster way to mauver?

"JMB" wrote:

Hit Cntrl+G and type D45 in the reference box.

"art" wrote:

Is there a way to make a shortcut to a go to a certain cell. lets say I want
to jump to cell D45 and I'm currently on cell A4, is there a way to jump
there with a shortcut, like if in cell D45 sais Freezer, and I type "F", it
should jump to that cell?


JMB

Shortcut to go a certain cell
 
If you already know the cell reference (or approximate cell reference), you
can also type the cell reference in the name box (upper left, next to the
formula bar). If the cell reference varies and you are searching for
"Freezer", try Cntrl+F (or click Edit/Find) to search for it.

"art" wrote:

Thanks. Do you have any other shortcuts, or a faster way to mauver?

"JMB" wrote:

Hit Cntrl+G and type D45 in the reference box.

"art" wrote:

Is there a way to make a shortcut to a go to a certain cell. lets say I want
to jump to cell D45 and I'm currently on cell A4, is there a way to jump
there with a shortcut, like if in cell D45 sais Freezer, and I type "F", it
should jump to that cell?



All times are GMT +1. The time now is 03:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com