Excel 2000 - adding rows
 

I have a document 500 rows long. Each row has text. I would like to insert
a blank row after every row that text is in, leaving a document that has a
blank row every other row. Can't seem to locate an easy answer. I thought
holding the CTRL button would do it (while selecting) but not so. Can anyone
help?

Excel 2000 - adding rows
 

Here's one method, using a helper column.

Insert a new column adjacent to your data
In row 1, enter the value 1, then enter 3 in row 2
Use the fill handle to extend this range down through row 500
Then, in row 501, enter the value 2, then enter 4 in row 502
Use the fill handle to extend this range down through row 1000
Now, Select all of your data, including the helper column down through row
1000
Sort the data Ascending by the helper column.
You can now delete the helper column.

HTH,
Elkar


"BBB Jean" wrote:

I have a document 500 rows long. Each row has text. I would like to insert
a blank row after every row that text is in, leaving a document that has a
blank row every other row. Can't seem to locate an easy answer. I thought
holding the CTRL button would do it (while selecting) but not so. Can anyone
help?

Excel 2000 - adding rows
 

I really would like to try this, however, I am a novice. Where is the fill
handle?
--
BBB Jean


"Elkar" wrote:

Here's one method, using a helper column.

Insert a new column adjacent to your data
In row 1, enter the value 1, then enter 3 in row 2
Use the fill handle to extend this range down through row 500
Then, in row 501, enter the value 2, then enter 4 in row 502
Use the fill handle to extend this range down through row 1000
Now, Select all of your data, including the helper column down through row
1000
Sort the data Ascending by the helper column.
You can now delete the helper column.

HTH,
Elkar


"BBB Jean" wrote:

I have a document 500 rows long. Each row has text. I would like to insert
a blank row after every row that text is in, leaving a document that has a
blank row every other row. Can't seem to locate an easy answer. I thought
holding the CTRL button would do it (while selecting) but not so. Can anyone
help?

Excel 2000 - adding rows
 

Once you've entered the 1 and 3 in the first two cells, use the mouse to
highlight both cells. In the bottom-right corner of the selection, you
should see a small box. Move you mouse over this box (the cursor should
change appearance), then click and drag the selection down as far as needed.

HTH,
Elkar


"BBB Jean" wrote:

I really would like to try this, however, I am a novice. Where is the fill
handle?
--
BBB Jean


"Elkar" wrote:

Here's one method, using a helper column.

Insert a new column adjacent to your data
In row 1, enter the value 1, then enter 3 in row 2
Use the fill handle to extend this range down through row 500
Then, in row 501, enter the value 2, then enter 4 in row 502
Use the fill handle to extend this range down through row 1000
Now, Select all of your data, including the helper column down through row
1000
Sort the data Ascending by the helper column.
You can now delete the helper column.

HTH,
Elkar


"BBB Jean" wrote:

I have a document 500 rows long. Each row has text. I would like to insert
a blank row after every row that text is in, leaving a document that has a
blank row every other row. Can't seem to locate an easy answer. I thought
holding the CTRL button would do it (while selecting) but not so. Can anyone
help?

Excel 2000 - adding rows
 

If just for appearance sake, I would double the row heights to give the illusion
of double-spacing.

Having blank rows could lead to problems later with copying, sorting, filtering,
pasting and other functions.


Gord Dibben MS Excel MVP

On Fri, 27 Jul 2007 09:58:03 -0700, BBB Jean <BBB
wrote:

I have a document 500 rows long. Each row has text. I would like to insert
a blank row after every row that text is in, leaving a document that has a
blank row every other row. Can't seem to locate an easy answer. I thought
holding the CTRL button would do it (while selecting) but not so. Can anyone
help?