automatic wrap

  • Thread starter Thread starter lucy
  • Start date Start date
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?
 
Hi
one way: select your entry reange (highlight it before
starting entering values
 
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
 
You must log in or register to reply here.

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

Auto Row Height with Wrapped Text in Merged Cells Problem 3
What controls row expansion to show muli-line text in a word-wrap 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
wrapped text in cells not displaying 2
How do I autofit row height to adjust to new text on Excel form? 1
Resizing merged / wrapped cells. 2
Merged cells stop wrapping 4
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0

Back
Top