Paste Special IV: Inserting rows
Another quick tip illustrating the versatility of the Paste Special function.
To insert an empty row into an existing table…
Step 1: Select and Copy a single empty cell in your table.
Step 2: Select the row above which you wish to insert an empty row - then select Edit - Paste Special - below…
The key setting has been circled. Existing selection is shifted down while blank cell is copied across the table
The end result is shown below.
