Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How can I delete empty lines in OpenOffice Calc?

share|improve this question
Lines within cells or empty rows? – Linker3000 Jun 17 '11 at 10:07
Also, do you want to automatically (like batch) delete them all or just manually delete them? – slhck Jun 17 '11 at 10:11
@LanceBaynes, our answers helped you? Assign "the answer" to one of given solutions :) – kokbira Jun 5 '12 at 12:50

Try that:

  1. Select all (CTRL+A);

  2. Sort alphabetically+crescent (select that button in toolbar or Data > Classify > Choose by the first column and crescent);

So you will have all empty rows at the end and you will have to remove only if there is some formatting.

That technique would not be much efficient if you have sparse data (a lot of empty cells between data) in "table" without a "custom header" (if you have not put the first line with the name of columns).

PS: Sometimes when I sort data on table, it sorts also the header, so it is moved from the top of worksheet to another position. To avoid that, freeze header row/rows before sorting.

share|improve this answer

Right-click the column or row header, and a pop-up menu will appear. Then click Delete Row or Delete Column.

Optionally, you can select multiple rows or columns first, in which case you can delete them all at once.

share|improve this answer

Your Answer


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.