Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Between Specific Cells
Greetings all,
I am using Excel 2007. I have a spreadsheet that I want the users to input data into specific cells that I have hi-lighted. There are a little over 20 cells that they need to fill in. When the user completes the cell, I want them to hit either the tab key or enter and move to the next cell. I have tried protecting the spreadsheet and unlocking all of the cells that I want them to use, however, due to the merging of some cells, when you hit tab it takes you into a loop and will not select the remaining cells, so the user has to click on the cell to select it manually. Is there a way to have the cursor go these specific twenty cells, in order, other than the way that I have tried above? Thanks as always for your help! Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving Between Cells | Excel Discussion (Misc queries) | |||
Arrow Keys Moving Window Frame instead of Moving Between Cells | Excel Discussion (Misc queries) | |||
Moving to a specific worksheet | Excel Discussion (Misc queries) | |||
finding blank cell and moving specific data into it | Excel Worksheet Functions | |||
Moving a line of data when information is entered in a specific cell. | Excel Discussion (Misc queries) |