#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default tabbed movements

I know there is a way to use the tab key to move from one specific cell to
another nonadjoining specific cell - just don't know how...
thanks for any help
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,722
Default tabbed movements

Under cell format, protection, you can unlock a cell.
When a sheet is protected (and you allow unprotected cells to be selected),
"tab" moves from one unprotected cell to the next, skipping the protected one.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"alpineuser" wrote:

I know there is a way to use the tab key to move from one specific cell to
another nonadjoining specific cell - just don't know how...
thanks for any help

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default tabbed movements

Couple of methods for "tab"bing or "enter"ing to cells can be found at Bob
Phillips' site.

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

There is also a couple of VBA methods.

Post back if interested in one.


Gord Dibben MS Excel MVP

On Tue, 8 Sep 2009 12:18:07 -0700, alpineuser
wrote:

I know there is a way to use the tab key to move from one specific cell to
another nonadjoining specific cell - just don't know how...
thanks for any help


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
Automatically select a cell when tabbed to questor Excel Discussion (Misc queries) 0 September 13th 07 11:58 PM
How do I create dynamic arrows that track movements Templeton Excel Worksheet Functions 5 March 23rd 06 02:20 AM
How can you enable a combobox to be "tabbed" or entered out of? Erika Excel Discussion (Misc queries) 0 April 22nd 05 02:41 PM
Getting combobox dropdowns to appear on a userform when tabbed to. DO Excel Discussion (Misc queries) 0 March 2nd 05 02:11 PM
formula and cell link movements wenrichards Excel Worksheet Functions 2 January 17th 05 09:36 AM


All times are GMT +1. The time now is 07:07 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"