Home |
Search |
Today's Posts |
#10
![]() |
|||
|
|||
![]()
Thank you Nick!! Have a good evening!!!
Julie "Nick Hodge" wrote: Gibbie If you unlock the cells you want to navigate to, (FormatCells...Protection) and then protect the worksheet. (ToolsProtectionProtect sheet), you can press tab to cycle through the cells unlocked -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Gibbie" wrote in message ... 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 "Gibbie" wrote: F5 does not work??? Can I set up a macros to move from cell to cell as data is entered?? "Nick Hodge" wrote: Gibbie Try F5 -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Gibbie" wrote in message ... How do you set up a shortcut key in a worksheet so that you can specify different cells to go to??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Navigating between worksheets. | Excel Worksheet Functions |