| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting cells between cells with text
I have over 300 questions and I need to insert a row after every question.
Is there a way to do this at one time without having to manually insert? -- Thanks Cr |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting cells between cells with text
WORK ON A COPY OF YOUR DATA
Insert a column next to your questions Next to the first question enter a 1, then move down one cell and enter a 3 Select the two cells, then double-click on the small black square at the bottom right of the cell containing the 3. You should end up with the questions all numbered from 1 to 600+. Immediately below the last number enter a 2 and in the cell below that enter a 4. Select the 2 cells and this time DRAG the little black square down until you reach 1 number higher than the highest of the first set of numbers Now select the 1 at the top of the column and DataSort You'll end up with a blank row between each of the questions "Cynthia" wrote: I have over 300 questions and I need to insert a row after every question. Is there a way to do this at one time without having to manually insert? -- Thanks Cr |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting cells between cells with text
That worked perfectly. Strange way of doing it but oh my goodness it worked.
Thank you so very much. -- Thanks Cr "Duke Carey" wrote: WORK ON A COPY OF YOUR DATA Insert a column next to your questions Next to the first question enter a 1, then move down one cell and enter a 3 Select the two cells, then double-click on the small black square at the bottom right of the cell containing the 3. You should end up with the questions all numbered from 1 to 600+. Immediately below the last number enter a 2 and in the cell below that enter a 4. Select the 2 cells and this time DRAG the little black square down until you reach 1 number higher than the highest of the first set of numbers Now select the 1 at the top of the column and DataSort You'll end up with a blank row between each of the questions "Cynthia" wrote: I have over 300 questions and I need to insert a row after every question. Is there a way to do this at one time without having to manually insert? -- Thanks Cr |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Question
How do I post to this group?
|
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Question
I guess you answered your own question, now the problem is of course if you
don't know that you did post to this group <bg -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Naomi" wrote in message ... How do I post to this group? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| question about removing text from cells, leaving numbers | Excel Discussion (Misc queries) | |||
| Maintaining cell references when inserting cells elsewhere | Excel Discussion (Misc queries) | |||
| Cells formated as text do not always display properly | Excel Discussion (Misc queries) | |||
Hybrid Mode
