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.
Posts: 22 | Location: Montreal | Registered: 08-03-04
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.
Posts: 9193 | Location: Atlanta, GA, USA | Registered: 06-03-02