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