can I ad blank rows every other row to a whole excel doc?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I got a file that's 5,000 rows long. Can I ad a blank row every other row so
it's easier to read w/o inserting a row 5,000 times over again?
 
You can but you might find that increasing the row height gives you muc
the same effect and does not lose functionality.

If you really want to insert rows post again here and I might put i
some code

regard
 
One other way I've seen suggested on this forum: In an empty column, number
1, 3. Select these two cells and drag down to row 5000. Excel should finish
the numbering. Then in the first empty cell in this column below your data
(row 5001), number 2, 4 and fill down to row 10,000. Then sort your data
using this helper column and delete it when you're done.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I insert blank rows between rows in completed worksheet? 1
Insert Row between items in list ... 2
Filtering times in Excel 2007 3
Insert blank rows 2
Insert Cells every other row 1
Force a filter beyond blank rows 1
Inserting a blank row after subtitle row 3
reference every other row 2

Back
Top