Welcome to the { mindfrost82.com } forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact us.

Go Back   { mindfrost82.com } > Gadget Corner > Tech Newsgroups > Microsoft > MS Office > Excel

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-13-2008, 03:10 PM
Diane
 
Posts: n/a
Tab to specific cells

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?


Reply With Quote
  #2 (permalink)  
Old 05-13-2008, 04:05 PM
RagDyeR
 
Posts: n/a
Re: Tab to specific cells

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.



--

HTH,

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


"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?



Reply With Quote
  #3 (permalink)  
Old 05-14-2008, 05:03 AM
Diane
 
Posts: n/a
Re: Tab to specific cells

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?
>



Reply With Quote
  #4 (permalink)  
Old 05-14-2008, 04:45 PM
RagDyeR
 
Posts: n/a
Re: Tab to specific cells

You're welcome, and appreciate your feed-back.
--

Regards,

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

"Diane" <diane58@telus.net> wrote in message
news:JwtWj.2560$KB3.1734@edtnps91...
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?
>




Reply With Quote
Reply

  { mindfrost82.com } > Gadget Corner > Tech Newsgroups > Microsoft > MS Office > Excel


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 04:30 PM.


Powered by vBulletin, Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0 ©2007, Crawlability, Inc.
© 1999-2008 mindfrost82.com v11.0


Sponsors:
MySpace Layouts | Per Insurance | Myspace Generators | Dirty Dozen Brass Band | Debt Help



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114