Insert blank row between data

Posted to microsoft.public.excel.programming

cbreed

external usenet poster

Posts: 1

Insert blank row between data

I hope someone can help!
I deal with hundreds of rows of data and need to insert a blank row i
between...so every other row is blank.
Data looks like:

Data
Data
Data
Data

Data needs to look like:

Data
Blank
Data
Blank
Data
Blank
Data

Is there an easy solution? I am not an advanced excel user

--
Message posted from http://www.ExcelForum.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Insert a blank row after change in data	Genghis2k3	Excel Worksheet Functions	3	January 11th 09 07:31 PM
Insert a blank row after change in data	Genghis2k3	Excel Worksheet Functions	1	March 28th 07 01:09 AM
How do I automatically insert a blank row between sets of data?	usdivers	Excel Discussion (Misc queries)	5	February 5th 07 01:45 PM
How can I insert a blank row after every row with data with Excel	margaret1115	Excel Discussion (Misc queries)	2	May 9th 06 11:02 PM
insert a blank row after data changes in a column	cyndi	Excel Discussion (Misc queries)	2	October 24th 05 02:46 PM

All times are GMT +1. The time now is 09:04 PM.

Menu

About Us