| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Thanks for your reply - I really appreciated your response.
"Ian" wrote: You won't be able to move in the order you quoted in your post, but you could leave the required cells unlocked and tab between them. This method works by rows, that is, it looks for the next available cell on the current row and if it doesn't find any tries the next row and so on until it finds an unlocked cell. If you save the file with N1 selected, it would tab to N7 then C9 and back to N1. Obviously there are more cells you need, but it might be worth a look. Select each of the cells you want to populate and set the cell protection to unlocked (FormatCellsProtection uncheck Locked). Once this is done, protect the worksheet (ToolsProtectionProtect Sheet). By using tab, you will automatically jump to the next available cell, those available are the ones you have unlocked. -- Ian -- "J9Y" wrote in message ... I'm working with an invoice document that someone created on Excel 2003. It's a great document, but we want to program either the TAB key or the ENTER key to move to a different cell within the worksheet. Example: After typing the Date, enter automatically to Invoice Number, then enter automatically to Company Name, and so on. Is there a way to start at cell N1 ,then program the Enter key to automatically go to cell N7 after that, then C9 after that and so on. Any information is GREATLY appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to move to next cell by entering data-not using Enter key. | Excel Discussion (Misc queries) | |||
| Enter, tab, arrow keys aren't allowing me to move to other cells | Excel Discussion (Misc queries) | |||
| Can't move from one cell and/or enter any data, or exit wksht... | Excel Discussion (Misc queries) | |||
| Formula referencing deleted row (move up automatically) | Excel Worksheet Functions | |||
| After scanning a barcode how can I automatically move to the next. | Excel Discussion (Misc queries) | |||
Threaded Mode
