adding rows in an entire spreadsheet

[Red Cedar]

I have a large spreadsheet with no blank rows. I wish to add a blank row between each row of data. Surely, I don't have to do this one row at a time! Thank you. Also, what are "smilies" and "BBcode"?

 

[caladin0668]

Try using a macro with step 2.

For x = 2 to N step 2
(code for inserting row)
next x

 

[Chris Davison]

this is a smilie :



achieved by typing the colon then the dash then the close-parenthesis

BB Code when OFF switches off any HTML commands (Hypertext Markup Language - the commands that intruct your browser to display appropriately) as sometimes the typing that explainins your excel formula porblems is interpretted as HTML, so Mr Excel has given us the ability to switch this off.