Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i set up tab field priority?
I have a worksheet that i have protected. The fields that are not protected
i want to be able to move throu them with the tab button straight down then to the left side. Right now i go from right to left fields. Is there a way I can set it up to go straight down the sheet then go to the right cells last? |
#2
|
|||
|
|||
Snipped from a Gord Dibben post:
One method is......make a named range for your cells then select this name from the namebox. Assume you want to go from D10 to A1 to B4 to C8 Hold CRTL key down as you select cells. Start with second cell(A1 in this case) then select B4, C8 and last D10. With cells still selected, go to InsertNameDefine. Type in a name and OK. De-select cells by clicking on any other cell. Now click on namebox(just above row1 and left of column A. Pick your name from the list. Your range will be highlighted with D10 as active cell. Enter your data then hit ENTER key to move through the range. Debbie wrote: I have a worksheet that i have protected. The fields that are not protected i want to be able to move throu them with the tab button straight down then to the left side. Right now i go from right to left fields. Is there a way I can set it up to go straight down the sheet then go to the right cells last? -- Dave Peterson |
#3
|
|||
|
|||
Described in detail at http://www.xldynamic.com/source/xld.xlFAQ0008.html
(with accreditation to Gord) -- HTH Bob Phillips "Dave Peterson" wrote in message ... Snipped from a Gord Dibben post: One method is......make a named range for your cells then select this name from the namebox. Assume you want to go from D10 to A1 to B4 to C8 Hold CRTL key down as you select cells. Start with second cell(A1 in this case) then select B4, C8 and last D10. With cells still selected, go to InsertNameDefine. Type in a name and OK. De-select cells by clicking on any other cell. Now click on namebox(just above row1 and left of column A. Pick your name from the list. Your range will be highlighted with D10 as active cell. Enter your data then hit ENTER key to move through the range. Debbie wrote: I have a worksheet that i have protected. The fields that are not protected i want to be able to move throu them with the tab button straight down then to the left side. Right now i go from right to left fields. Is there a way I can set it up to go straight down the sheet then go to the right cells last? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table field types | Excel Discussion (Misc queries) | |||
Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
Help needed with priority list | Excel Worksheet Functions |