adding rows in an entire spreadsheet

Red Cedar · Apr 20th, 2002, 06:56 AM

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 · Apr 20th, 2002, 07:04 AM

Try using a macro with step 2.

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

Chris Davison · Apr 20th, 2002, 07:34 AM

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.

Apr 20th, 2002, 07:34 AM	#3
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	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. __________________ :: Pharma Z - Family drugstore ::

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 20th, 2002, 06:56 AM	#1
Red Cedar New Member Join Date: Apr 2002 Posts: 1	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"?

Apr 20th, 2002, 07:04 AM	#2
caladin0668 New Member Join Date: Apr 2002 Posts: 1	Try using a macro with step 2. For x = 2 to N step 2 (code for inserting row) next x