How can I insert a blank row after every row with data with Excel
If it's only for reading, maybe you could just double the rowheight of each row.
If the rows are all the same height, you can select all the rows (a few ctrl-a
keystrokes), then just change the rowheight:
Format|row|height
(and double the value there)
margaret1115 wrote:
I need to insert a blank row after every row containing data (to facilitate
reading and adding survey data by hand) in an Excel spreadsheet. Is there any
way to do so automatically by selecting the data then doing some menu option
or keystroke? I can add a blank row with a macro but that is only a bit less
laborious than having to add each blank row by hand. Thank you for your help.
Margaret
--
Dave Peterson
|