Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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: 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 -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dave, I'm not following you. I'm sorry but can you give the 1st grader
version of you instructions? Thanks. -- Lee Davenport "Dave Peterson" wrote: 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: 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 -- Dave Peterson |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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: Dave, I'm not following you. I'm sorry but can you give the 1st grader version of you instructions? Thanks. -- Lee Davenport "Dave Peterson" wrote: 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: 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 -- Dave Peterson -- Dave Peterson |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks
-- Lee Davenport "Dave Peterson" wrote: 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: Dave, I'm not following you. I'm sorry but can you give the 1st grader version of you instructions? Thanks. -- Lee Davenport "Dave Peterson" wrote: 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: 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 -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
out of a group of cells, if max, then display this other cell | Excel Worksheet Functions | |||
how to change a formula for a large group of cells | Excel Worksheet Functions | |||
Formatting a range of cells doesn't work | Excel Discussion (Misc queries) | |||
Excel should allow more options for formatting cells | Excel Worksheet Functions | |||
Formatting cells in Excel for certain Values to appear certain Col | Excel Worksheet Functions |