Forum Discussion
Adding blank row every other row to spreadsheet
Can anyone advise how to set up a spreadsheet so that multiple rows of information can be pasted into the spreadsheet leaving every other row blank? Ideally I would also like to have the blank row b...
If you don't want to use a filter you can also:
- Insert 2 columns to the left of your data
- In column 1 row 1 enter something (anything will do. I entered "a")
- In column 2 row 2 enter something
- Select and drag down however far you need (so every other cell is blank in both columns, but no two blanks are touching)
- With all those cells still selected, click F5 --> Special --> Blanks
- Right click any selected cell and chose Insert --> Entire Row