Navigating

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

Guest

How do you set up a shortcut key in a worksheet so that you can specify
different cells to go to???
 
Gibbie

Try F5

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
F5 does not work??? Can I set up a macros to move from cell to cell as data
is entered??
 
In what way does it not work - What happens or works differently to what you
expected. You can also type a cell reference straight into the box above
column A and hit the Enter key.
 
Gibbie

We appear to be getting clues to your requirement ;-)

F5 will give you the 'go to' dialog to move to other cells, as in your
original request. So that should work.

If you want to move to specific cells, what are they as the macro code will
need to know that?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Yes F5 works, but I want to navigate automatically to another cell in the
spreadsheet when I hit the tab key or a specified shortcut key. Will that
work??

Thanks very much
 
Well you can tell I'm not a programmer.......:)

The cells are as follows:
E7, S7,
E9, U9
B14, D14, H14, L14, O14
B16, D16, H16, L16, O16
B18, D18, H18, L18, O18
E21
E23
T23, T24, T25, T26


Many thanks
 
Gibbie

If you unlock the cells you want to navigate to,
(Format>Cells...>Protection) and then protect the worksheet.
(Tools>Protection>Protect sheet), you can press tab to cycle through the
cells unlocked

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Ken,

I think my keys were locked as the F5 function was not working.....got it
now!!
 
Thank you Nick!! Have a good evening!!!

Julie

Nick Hodge said:
Gibbie

If you unlock the cells you want to navigate to,
(Format>Cells...>Protection) and then protect the worksheet.
(Tools>Protection>Protect sheet), you can press tab to cycle through the
cells unlocked

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lost Arrow key navigation 1
How do I disable pre-loaded shortcut? 1
Goto specified date 3
navigation 3
Cell Navigation 2
Keyboard Shortcut 3
Navigate in a big worksheet 4
Shortcut for sheet tabs, name box, outline buttons 1

Back
Top