Hi y'all!!

I have an excel spreadsheet at work that has over 2000 lines. It's real hard to read, so I want to put a space in between each line.

Is there a shortcut that will do this for the whole worksheet (or even large portions of it) or do I have to "insert" from now til Christmas to get those lines in there?

Thanks, friends!

I took a look at your request, Cyndi, and I am unable to see how that can be done easily outside of a script. However, I suggest you might think about this way:

Format the text:
Highlight all the text that you wish to change. (Simply pressing CTRL+A will highlight the entire worksheet)
Right click anywhere in the highlighted section and choose 'Format Cells'
In the box that appears enter 25.5, this will double the height of the rows.
Then select: Tools --> Options
in options make sure the View tab is selected
Look at the section: Window Options
where it says Gridlines, uncheck the box so that it is blank.
Click ok

This will space out the rows and clear the grid lines on the sheet, making it very easy to read.
You can still navigate around the spreadsheet using the same commands etc.

Have fun!

Appoligies... for Format Cells, read: Row Height!!

Hey I have an excuse, I have just woken up and in desperate need of a caffiene transfusion!

Cyndi, I don't think there is an automatic way to insert between your lines of data but there is a shortcut that will eliminate manually inserting after every line. On each line click a different cell in a different column. Just hold down the Ctrl key as you select each cell in each row. They don't have to be diagonal but they do have to be in a different column than the above cell selected. Then on your toolbar click on the "insert row" tool button (or under Insert menu select "row") This will automatically insert a row between each line of data as far as you have selected the cells.

For example, if your sheet has 6 columns used then you could select A1, B2, C3, D4, E5, F6.
Then "insert row" and you will now have empty rows between rows 1, 2, 3, 4, 5, 6. If you have the patience you can select the cells throughout your entire worksheet and automatically insert the rows at one time. But it's probably a little easier to do rows of 10 or so at a time.

Thanks, y'all....Wound up doing as Georgia suggested, a few at a time

Hey! Glad that worked for ya

If I'd gotten to read this before Georgia replied, I'd have given you the same suggestion she did. I think that's the only way to do it.