ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   tab order (https://www.excelbanter.com/excel-discussion-misc-queries/32650-tab-order.html)

daolb

tab order
 

can you specify a tab order in excel?


for example. can I specify the folowwing tab order:


b1
b2
b3
b4
b10
b11
b12

and ofcourse how?

gracias


--
daolb
------------------------------------------------------------------------
daolb's Profile: http://www.excelforum.com/member.php...o&userid=24478
View this thread: http://www.excelforum.com/showthread...hreadid=382504


Bob Phillips

Take a look at http://www.xldynamic.com/source/xld.xlFAQ0008.html

--
HTH

Bob Phillips

"daolb" wrote in
message ...

can you specify a tab order in excel?


for example. can I specify the folowwing tab order:


b1
b2
b3
b4
b10
b11
b12

and ofcourse how?

gracias


--
daolb
------------------------------------------------------------------------
daolb's Profile:

http://www.excelforum.com/member.php...o&userid=24478
View this thread: http://www.excelforum.com/showthread...hreadid=382504




Paul B

daold, have a look here for one way,

http://www.xldynamic.com/source/xld.xlFAQ0008.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"daolb" wrote in
message ...

can you specify a tab order in excel?


for example. can I specify the folowwing tab order:


b1
b2
b3
b4
b10
b11
b12

and ofcourse how?

gracias


--
daolb
------------------------------------------------------------------------
daolb's Profile:

http://www.excelforum.com/member.php...o&userid=24478
View this thread: http://www.excelforum.com/showthread...hreadid=382504




swatsp0p


The only way I know of would be to 'Unlock' the desired cells to tab
into then Protect the sheet, allowing ONLY Select Unlocked Cells.
Tabbing will then scroll through the unlocked cells.

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=382504



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com