Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / May 2008

Tip: Looking for answers? Try searching our database.

Tab to specific cells

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Diane - 13 May 2008 15:10 GMT
I am using excel 2002 and my boss 2003.  I want to tab to specific cells in
my work sheet. Can anyone help me get started?
RagDyeR - 13 May 2008 16:05 GMT
You could try the named range approach.

Select your *second* cell for data entry and then hold down <Ctrl> and
continue to select all the rest of the desired cells in order, ending with
selecting your *first* cell *last*.
While the cells are still selected, click in the name box and give this
range a short name such as "Entry1".

Now, when you're ready for data entry, simply click on the range name in the
name box.  The focus for the range is the first cell  for data input so all
you have to now do, is type your data and hit enter and the focus then moves
to each successive cell in your range.  Just click away to break out of the
loop.

You can of course enter numerous "data entry ranges" with slightly different
names.
These named ranges are WB specific however, so for example, if you wish to
use the same name for the first entry on other sheets of the same WB, you
will have to prefix the range name with the WS name followed with an
exclamation point.

For example:
Sheet1!Entry1
Sheet1!Entry2

Sheet2!Entry1
Sheet2!Entry2 ... etc.

Signature

HTH,

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

I am using excel 2002 and my boss 2003.  I want to tab to specific cells in
my work sheet. Can anyone help me get started?
Diane - 14 May 2008 05:03 GMT
Thank you so much for your help.  It is easy and works!!

All the best to you!
>I am using excel 2002 and my boss 2003.  I want to tab to specific cells in
>my work sheet. Can anyone help me get started?
RagDyeR - 14 May 2008 16:45 GMT
You're welcome, and appreciate your feed-back.
Signature


Regards,

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

Thank you so much for your help.  It is easy and works!!

All the best to you!
"Diane" <diane58@telus.net> wrote in message
news:pjhWj.2373$KB3.1017@edtnps91...
>I am using excel 2002 and my boss 2003.  I want to tab to specific cells in
>my work sheet. Can anyone help me get started?

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.