Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Debbie
 
Posts: n/a
Default 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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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   Report Post  
Bob Phillips
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot table field types stevehere Excel Discussion (Misc queries) 2 June 1st 05 11:54 AM
Stop text from stringing into next field when empty NothingButRomance Excel Worksheet Functions 7 May 17th 05 02:22 AM
Stop text from stringing into next field when empty NothingButRomance Excel Worksheet Functions 2 May 15th 05 05:32 PM
Problems with Pivot Table Field Sorting in Excel 2002 Phoenix71555 Excel Discussion (Misc queries) 1 February 28th 05 12:25 AM
Help needed with priority list _SPCA Excel Worksheet Functions 0 January 20th 05 11:24 PM


All times are GMT +1. The time now is 04:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"