Formatting a group of cells for text

G

Guest

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.
 
G

Guest

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...
 
G

Guest

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

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

Excel Conditional Formatting 1
another formular help please 2
formula for if a cell reaches a certain value 5
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
Cells ignore Wrap Text formatting! 2
Combining Text From Cells 3
Looking at multiple cells 3
Text Color Changes By Itself 3

Top