Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft excel courses london - inserting rows after group

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses london - Inserting Rows after a group of existing rows

microsoft excel courses london - Inserting Rows after a group of existing rows

ResolvedVersion Standard

Gabriel has attended:
Excel Advanced course

Inserting Rows after a group of existing rows

How do you insert individual rows after existing rows already in a spreadsheet so that underneath each row is a blank row? At the moment I am having to select each individual row and then select insert row, but this is quite time consuming when you have a lot of data to work with.

RE: Inserting Rows after a group of existing rows

Hi Gabriel,

I assume you're inserting data in the middle of your spreadsheet. One way would be to just insert data at the end of your spreadsheet, where all the rows will be blank already.

One shortcut is Control-+ (Control + plus key) which brings up the Insert dialogue box. From there you can use arrow down key to select Entire Row, then Enter.

Control++ assumes you want to select a row if a row is already selected, so you could select a row (Shift+Space) then Insert (Control-+).

Another way is to record a macro. For example: Tools -> Macro -> Record New Macro -> type name (eg. InsertRow); assign shortcut key (eg. Control+R) -> Press OK button (you're now recording) -> Go to Insert -> Rows -> Press Stop button on floating toolbar. Now whenever you press Control+R, a row will be inserted.

If you want to insert many rows at once, try selecting (eg. 10) rows using the numbers on the side, then right click one of the numbers and choose Insert. This will insert X rows where X is the amount of rows you've got selected. This could speed things up a bit for you.

I hope these suggestions have been a help. If it has, please mark this question as resolved, otherwise, please provide more detail and we'll try to help.

Regards, Rich

Excel tip:

Select blank cells automatically

Get Excel to find any blank (empty) cells in a region for you by:

1. Selecting the appropriate region from your spreadsheet.

2. On the menu bar, go to Edit - Go to.

3. Click the 'Special' button, then select Blanks and click OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.