|
Navigating
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 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??? |
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??? |
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. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Gibbie" wrote in message ... 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??? |
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 HIS "Gibbie" wrote in message ... 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??? |
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??? |
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 "Nick Hodge" wrote: 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 HIS "Gibbie" wrote in message ... 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??? |
Ken,
I think my keys were locked as the F5 function was not working.....got it now!! "Ken Wright" wrote: 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. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Gibbie" wrote in message ... 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??? |
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??? |
| All times are GMT +1. The time now is 01:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com