Inserting Blank Lines

L

LPM

Hello all. I need some help and hope someone out there can assist me.

I have a spreadsheet with 100 or so lines with serveral columns goin
across. I want to insert a blank line in between each line tha
contains data. Is this possible?

Thank you for your help.
LPM :
 
P

Paul Sheppard

LPM said:
Hello all. I need some help and hope someone out there can assist me.

I have a spreadsheet with 100 or so lines with serveral columns going
across. I want to insert a blank line in between each line that
contains data. Is this possible?

Thank you for your help.
LPM :)
Click to expand...

Hi LPM

Select row 1, hold down the CTRL key select row 2, continue to the end
until row 99 is selected, then right click and click on insert, a row
will be inserted between each data row
 
A

aaron.kempf

yeah.. if you kept your DATA in a DATABASE this would be a lot easier
in an access report
 
L

LPM

Paul,
It did not work..... it says, " CANNOT USE THAT COMMAND ON OVERLAPPING
SLECTIONS.... Any ideas?
 
G

George Nicholson

If this is just a cosmetic thing, could you acheive the desire results by
selecting all rows and doubling their height? Inserting blank rows makes any
filtering, sorting, etc. soooo much harder (if not impossible), I'd avoid it
unless necessary.

HTH,
 
Top