ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I want to jump to different cells with tab (https://www.excelbanter.com/excel-discussion-misc-queries/97276-i-want-jump-different-cells-tab.html)

A-s

I want to jump to different cells with tab
 
Hi !

when i press tab the marker just jumps to the right i want to make i jump to
a selected cell... how can i do sometinhg like that ?? :)

Bill Ridgeway

I want to jump to different cells with tab
 
I don't think you can do that.

You can, however, press <F5, type in the cell reference and press <OK

If you will be wanting to go to a particular cell regularly you may be able
to write a macro (but I'm not into that).

Regards.

Bill Ridgeway
Computer Solutions

"A-s" wrote in message
...
Hi !

when i press tab the marker just jumps to the right i want to make i jump
to
a selected cell... how can i do sometinhg like that ?? :)




MartinW

I want to jump to different cells with tab
 
Hi A-s,

If you use sheet protection and uncheck 'select locked cells'
then using tab or the arrows will jump from unlocked cell
to unlocked cell.

I'm not sure in which version this option was first offered
I think it was 2002

HTH
Martin



RagDyeR

I want to jump to different cells with tab
 
You can use a "Named Range".

See if this old post explains it well enough.

http://tinyurl.com/39vzv

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"A-s" wrote in message
...
Hi !

when i press tab the marker just jumps to the right i want to make i jump

to
a selected cell... how can i do sometinhg like that ?? :)




All times are GMT +1. The time now is 02:19 AM.

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