Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel add row after each existing row


  • Please log in to reply

#1
abstraxtion

abstraxtion

    New Member

  • Member
  • Pip
  • 1 posts
Hello,

wondering if anyone can help me out. my mom works as a secretary. Her new boss gave her 28 existing spreadsheats in excel 97, all of which have 250-400 rows of info. He wants her to insert a row after each existing row. Is there a quick way to do this? I have tried everything I can think of but i dont know excel very well and so far nothing works. I tried to create a macro, but the macro keeps inserting rows only after the first selected row. any ideas greatly appreciated,

dino :tazz:
  • 0

Advertisements


#2
dsm

dsm

    Member

  • Member
  • PipPip
  • 98 posts
Dino,
You have at least 2 options.

1. You could write some VB code to do this, but there is an easier method.

2. Easy Method
-Inset a new column before column A
-In the new column type in a sequential number for each cell from 1 to 400 (assuming there a 400 records)
(you can use autofill to do this)
-Copy the numbered cells and paste them in column A below the last value
-Highlight entire sheet and then sort by column A then B
-Column A should now look like;
1
1
2
2
3
3
4
4
...
...
400
400

-Every second line should be blank except for the number in column A
-Delete column A


HTH
David
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP