Setting cell tabulations( ranges) in excell

G

Guest

I would like to set a ranage for tabulation; the row starts with "Week day
and ends with END". You can automatically tab from WEEK day to END but to
speed things up I want the tab to go to the next row once it reaches" End".
instead of going to the next empty cell on the same row.

How can I set a tabulation range?

Example:
Week Day Date Shift Start Lunch In Lunch Out Shift End

Wednesday 18-Aug-04
Thursday 19-Aug-04
 
D

Dave Peterson

If you select your cells (say B2:H999) first, you can tab between the cells in
the selection.
 
G

Gord Dibben

TAB your way across. When you get to End cell, enter your data then hit the
<ENTER> key to return to first column one row down.

Make sure Tools>Options>Edit "move selection after enter" is set to "down".

Gord Dibben Excel MVP

On Sun, 19 Sep 2004 16:45:01 -0700, dizzy kay <dizzy
 

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

hiding columns in Excell error message 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Index Match Help 6
identifying the next working day after weekends and/or holidays 2
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Using Excel 2003 1
lable ranges in Excell 2
excel timesheet and drop down boxes 3

Top