Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I select specific cells to be my tab stops?
I am a new user and I created an Excel document that I want to use as a form.
Some of the cells have a default text that I do not want to change (for example: "ADDRESS"). Other cells are empty where I would like to type in info. Is there a way to select the cells in a specific order so that when I press the TAB or ENTER key(s) the cursor will move to a cell where I would like to type rather than simply to the next cell? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I select specific cells to be my tab stops?
Tab Stops In Excel (JTurke) wrote:
I am a new user and I created an Excel document that I want to use as a form. Some of the cells have a default text that I do not want to change (for example: "ADDRESS"). Other cells are empty where I would like to type in info. Is there a way to select the cells in a specific order so that when I press the TAB or ENTER key(s) the cursor will move to a cell where I would like to type rather than simply to the next cell? Select the entire sheet and then Format / Cells / Protection. Make sure "Locked" is checked and then click OK. Now select all of the cells into which you would like to be able to enter information. If they are not all connected to each other, select the first range, then hold down the "Ctrl" key and continue to select additional ranges. Next, Format / Cells / Protection and un-check "Locked". Finally, Tools / Protection / Protect Sheet and check all the things you want to do, making sure that "Select locked cells" is un-checked. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I select specific cells to be my tab stops?
Hi,
The only way to do what you requested is to use VBA. Why? Because the other answer you were given does not move the cursor in "a specific order" it moves them in to order Excel is pre-designed to. In other words if you have the range A1:A5 unlocked in a protected spreadsheet . If you want the cursor to move in this order, it won't A3--A1--A5--A2--A4 If you start in A1 and press Tab the cursor will always move to A2. If you press Enter in A1, of this example, the cursor will move to A2. To go in any non-standard order you must program Excel. To do that we would need the "specific order" you want to move through the range. -- Thanks, Shane Devenshire "Tab Stops In Excel (JTurke)" wrote: I am a new user and I created an Excel document that I want to use as a form. Some of the cells have a default text that I do not want to change (for example: "ADDRESS"). Other cells are empty where I would like to type in info. Is there a way to select the cells in a specific order so that when I press the TAB or ENTER key(s) the cursor will move to a cell where I would like to type rather than simply to the next cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I select cells within a column that contain a specific word | Excel Worksheet Functions | |||
select cells that sum up to a specific value | Excel Discussion (Misc queries) | |||
How do I set the tab stops in a specific cell pattern? | Excel Worksheet Functions | |||
how to select specific cells to product a chart | Excel Discussion (Misc queries) | |||
How do I pause a macro to select specific cells | Excel Worksheet Functions |