Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I was wondering in Openoffice Calc spreadsheet, how to add a line between every two rows? I want to print a spreadsheet, with a line separating every two rows. Thanks and regards!

share|improve this question

2 Answers 2

I think you will find it easier with both Calc and Excel to select the rows, right-click -> Row height and then enter double the current row height.

If you really want a blank row between each:

  • add a column
  • Put numbers 1, 2, ..., n for each of your rows
  • Put 1.5, 2.5, ..., n+.5 in each of the blank rows following row n
  • Sort by that column (this will "Faro shuffle" your original and blank rows)
  • delete that column

Doesn't the first option sound a lot better?

share|improve this answer

You could add a column. Select the cells in the new column for the desired rows. edit/fill/series (start with "1") and press enter. Select an equal number of cells in the new column below the desired rows. edit/fill/series (start with "1.5"). Select all cells. data/sort/column "A". Delete the new column.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.