How to Reverse the Row Order in LibreOffice Calc [Quick Tips]

Let ‘s say that you are using LibreOffice Calc to open up a spreadsheet (or csv file) that your friend send to you, only to find that the rows are in the reverse order that you want them, i.e. the first row is at the last and the last is at the row. Assuming that the data is sorted in any order, how can you easily reverse the row order without having to manually copy/paste all the data to a new document?

This is easy. The following trick should work:

Note: This will also work in Ms Excel, OpenOffice and many other spreadsheet applications too.

1. Insert a new column at the extreme left (or right).

2. At the very first row, enter “1” (without the quote).

reverse-row-insert-column-left

3. Using your mouse, drag the first cell (the one that you just inserted “1”) and pull it down all the way to the end of the document. You should see all the cells below it populated with corresponding digit.

reverse-row-drag-copy-first-cell

4. Lastly, go to “Data -> Sort” on the menu bar. Under the “Sort Key 1” section, select the new column that you have created. Select “Descending” at the option beside it. Click OK.

reverse-row-sort-data

Tada. You have successfully reversed the row order of your spreadsheet.

Additionally, you may want to remove the new number column and save the spreadsheet with the correct row order.

Let us know if this trick works for you, or if you have an easier way to reverse the row.

3 comments

  1. It worked like a charm but the cells below 1 did not populate with corresponding digit. I had to enter them manually. Is there some way I can fix this?

    • Assume that the 1 is at the A1 cell, on B1 cell, you add the equation =A1+1. Next copy this B1 cell and paste to the whole column. The number will populate accordingly.

    • works for me well. Just give a ‘1’ in the A1 cell, then select the cell, there is a bold black dot at the bottom right of the cell and the mouse becomes a big ‘+’ on it. hold the left button and pull down, 2, 3, 4 will auto filled.
      @Damien, it’s a smart move. Hope this reverse a range/all rows function can be added into the software natively.

Comments are closed.

Sponsored Stories