automatic wrap

L

lucy

there is a way to set up a sheet so that when you reach
the end of a row the cursor automatically wraps to the
first cell of the following row. for example, after
entering data in row 100, cell j100, using tab or enter
takes you to row 101, cell 1. how do you do this?
 
F

Frank Kabel

Hi
one way: select your entry reange (highlight it before
starting entering values
 
G

Gord Dibben

One other way....

Start in A100, work your way across to J100 using the TAB key to leave each
cell after typing in your data.

Leave J100 by hitting the ENTER key to go to A101.

Another way.........

Unlock columns A through J and protect the worksheet.

TAB your way across to J100 then next TAB will take you to A101.

Gord Dibben Excel MVP
 
Top