#1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default HELP!

I am working in a document where I need to input data. I would like it to tab
from one cell to the next cell that needs data input. I looked at the change
the default tab order for controls on a form. I appears to be what I need,
however I do not know what they are talking about when they tell me to right
click on the control for which I want to change the tab order?
--
Jen
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 14
Default HELP!

Here's 1 way of achieving your goal.

Select all of the cells where you want to input data, then go to 'format
cells'. Under the protection tab, uncheck the "locked" option. Now, go to
'Tools' - 'Protection' - Protect Sheet. Select OK. You should now be able
to use the TAB key to go from one input cell to another.

Hope this helps!
--
Best Regards,

Luke Moraga


"Job Corps Jen" wrote:

I am working in a document where I need to input data. I would like it to tab
from one cell to the next cell that needs data input. I looked at the change
the default tab order for controls on a form. I appears to be what I need,
however I do not know what they are talking about when they tell me to right
click on the control for which I want to change the tab order?
--
Jen

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



All times are GMT +1. The time now is 05:11 PM.

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

About Us

"It's about Microsoft Excel"