Formatting a group of cells for text

L

Lee

Say you have a row of cells ( A1 to P1 ). I want to be able to type text into
that row of cells and when the text reaches the end of cell P1, it
automatically moves down to the next row of corrisponding cells (A2 to P2) to
continue what I was typing and do this this for as many corrisponding rows as
I need. Can I do his?
 
D

Dave Peterson

If you select A1:pxx, then you can type each entry and tab to the next cell.
It'll follow that pattern.

If you change tools|options|edit tab|move selection after enter to right, then
you can select that same range A1:pxx and hit enter to follow that pattern.
 
L

Lee

Dave, I'm not following you. I'm sorry but can you give the 1st grader
version of you instructions? Thanks.
 
D

Dave Peterson

Use your mouse to select A1:p4 (say).

Start typing something in A1.
When you're finished with what you want in A1, hit the tab key. You'll go to
B1.


Dave, I'm not following you. I'm sorry but can you give the 1st grader
version of you instructions? Thanks.
Click to expand...
 
L

Lee

Thanks
--
Lee Davenport


Dave Peterson said:
Use your mouse to select A1:p4 (say).

Start typing something in A1.
When you're finished with what you want in A1, hit the tab key. You'll go to
B1.
Click to expand...
 
Top