software

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

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 Datagt;Sort

You'll end up with a blank row between each of the questionsquot;Cynthiaquot; wrote:

gt; I have over 300 questions and I need to insert a row after every question.
gt; Is there a way to do this at one time without having to manually insert?
gt;
gt; --
gt; Thanks
gt; Cr

How do I post to this group?That worked perfectly. Strange way of doing it but oh my goodness it worked.
Thank you so very much.
--
Thanks
Crquot;Duke Careyquot; wrote:

gt; WORK ON A COPY OF YOUR DATA
gt;
gt; Insert a column next to your questions
gt;
gt; Next to the first question enter a 1, then move down one cell and enter a 3
gt;
gt; Select the two cells, then double-click on the small black square at the
gt; bottom right of the cell containing the 3. You should end up with the
gt; questions all numbered from 1 to 600 .
gt;
gt; Immediately below the last number enter a 2 and in the cell below that enter
gt; a 4.
gt;
gt; Select the 2 cells and this time DRAG the little black square down until you
gt; reach 1 number higher than the highest of the first set of numbers
gt;
gt; Now select the 1 at the top of the column and Datagt;Sort
gt;
gt; You'll end up with a blank row between each of the questions
gt;
gt;
gt; quot;Cynthiaquot; wrote:
gt;
gt; gt; I have over 300 questions and I need to insert a row after every question.
gt; gt; Is there a way to do this at one time without having to manually insert?
gt; gt;
gt; gt; --
gt; gt; Thanks
gt; gt; Cr

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 lt;bggt;--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;Naomiquot; gt; wrote in message
...
gt; How do I post to this group?
gt;