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?
--
Lee Davenport
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.
Lee wrote:
gt;
gt; Say you have a row of cells ( A1 to P1 ). I want to be able to type text into
gt; that row of cells and when the text reaches the end of cell P1, it
gt; automatically moves down to the next row of corrisponding cells (A2 to P2) to
gt; continue what I was typing and do this this for as many corrisponding rows as
gt; I need. Can I do his?
gt; --
gt; Lee Davenport
--
Dave Peterson
Dave, I'm not following you. I'm sorry but can you give the 1st grader
version of you instructions? Thanks.
--
Lee Davenportquot;Dave Petersonquot; wrote:
gt; If you select A1:Pxx, then you can type each entry and tab to the next cell.
gt; It'll follow that pattern.
gt;
gt; If you change tools|options|edit tab|move selection after enter to right, then
gt; you can select that same range A1:Pxx and hit enter to follow that pattern.
gt;
gt; Lee wrote:
gt; gt;
gt; gt; Say you have a row of cells ( A1 to P1 ). I want to be able to type text into
gt; gt; that row of cells and when the text reaches the end of cell P1, it
gt; gt; automatically moves down to the next row of corrisponding cells (A2 to P2) to
gt; gt; continue what I was typing and do this this for as many corrisponding rows as
gt; gt; I need. Can I do his?
gt; gt; --
gt; gt; Lee Davenport
gt;
gt; --
gt;
gt; Dave Peterson
gt;
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.
Lee wrote:
gt;
gt; Dave, I'm not following you. I'm sorry but can you give the 1st grader
gt; version of you instructions? Thanks.
gt; --
gt; Lee Davenport
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; If you select A1:Pxx, then you can type each entry and tab to the next cell.
gt; gt; It'll follow that pattern.
gt; gt;
gt; gt; If you change tools|options|edit tab|move selection after enter to right, then
gt; gt; you can select that same range A1:Pxx and hit enter to follow that pattern.
gt; gt;
gt; gt; Lee wrote:
gt; gt; gt;
gt; gt; gt; Say you have a row of cells ( A1 to P1 ). I want to be able to type text into
gt; gt; gt; that row of cells and when the text reaches the end of cell P1, it
gt; gt; gt; automatically moves down to the next row of corrisponding cells (A2 to P2) to
gt; gt; gt; continue what I was typing and do this this for as many corrisponding rows as
gt; gt; gt; I need. Can I do his?
gt; gt; gt; --
gt; gt; gt; Lee Davenport
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;
--
Dave Peterson
Thanks
--
Lee Davenportquot;Dave Petersonquot; wrote:
gt; Use your mouse to select A1:P4 (say).
gt;
gt; Start typing something in A1.
gt; When you're finished with what you want in A1, hit the tab key. You'll go to
gt; B1.
gt;
gt;
gt;
gt; Lee wrote:
gt; gt;
gt; gt; Dave, I'm not following you. I'm sorry but can you give the 1st grader
gt; gt; version of you instructions? Thanks.
gt; gt; --
gt; gt; Lee Davenport
gt; gt;
gt; gt; quot;Dave Petersonquot; wrote:
gt; gt;
gt; gt; gt; If you select A1:Pxx, then you can type each entry and tab to the next cell.
gt; gt; gt; It'll follow that pattern.
gt; gt; gt;
gt; gt; gt; If you change tools|options|edit tab|move selection after enter to right, then
gt; gt; gt; you can select that same range A1:Pxx and hit enter to follow that pattern.
gt; gt; gt;
gt; gt; gt; Lee wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; Say you have a row of cells ( A1 to P1 ). I want to be able to type text into
gt; gt; gt; gt; that row of cells and when the text reaches the end of cell P1, it
gt; gt; gt; gt; automatically moves down to the next row of corrisponding cells (A2 to P2) to
gt; gt; gt; gt; continue what I was typing and do this this for as many corrisponding rows as
gt; gt; gt; gt; I need. Can I do his?
gt; gt; gt; gt; --
gt; gt; gt; gt; Lee Davenport
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;
- Apr 21 Sat 2007 20:37
Formatting a group of cells for text
close
全站熱搜
留言列表
發表留言