Setting Tab Order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to control the cells I navigate to when pressing the tab key. I have protected the worksheet and some cells are locked, which are being skipped as I want. However, the only other settings I have been able to find are either tabbing down, then over OR over, then down. Is there a way to set the tab order of specific cells in Excel like you can in Access?

Thanks,
Shawn
 
One way to explicitly control the exact "next cell of focus" selection, is
to select the cells in the desired order of travel, and then preserve this
ordered movement by creating a named range.

This old post describes the steps that can be taken to create such a "named
range".

http://tinyurl.com/39vzv


--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I want to control the cells I navigate to when pressing the tab key. I have
protected the worksheet and some cells are locked, which are being skipped
as I want. However, the only other settings I have been able to find are
either tabbing down, then over OR over, then down. Is there a way to set the
tab order of specific cells in Excel like you can in Access?

Thanks,
Shawn
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protected Worksheet Tab Order 1
Excel; tabbing through protected worksheet 2
tabbing order 2
Locked cells in Excel 2000 1
Set Tab Order 1
Problems with macro, setting "tab order" of unprotected cells 3
spread sheet protection over several tabs 7
Tabbing Order of Unproteced Cells 3

Back
Top