1. Technical

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

reverse-row-thumbLet ‘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.

The post How to Reverse the Row Order in LibreOffice Calc [Quick Tips] appeared first on Make Tech Easier.



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

Recent Articles

Good Reads

Groundnut oil is a popular choice⁤ for cooking⁢ in many households due to ‍its ⁤versatility and health benefits. However, it is important to ensure that the groundnut oil you are⁣ using is of high quality and purity. In this guide, we will discuss simple and practical ways to identify top-notch groundnut oil for cooking, including […]
Larimar ‍is​ a ⁣stunning blue gemstone found exclusively in the Dominican Republic, known for ⁤its remarkable spiritual and‌ healing properties as well as its beauty. This captivating stone has long been associated with inner peace, emotional balance, and tranquility due​ to its intricate patterns reminiscent of the ocean and its serene shades of blue. The […]

Worlwide

Overview VipsPM – Project Management Suite is a Powerful web-based Application. VipsPM is a perfect tool to fulfill all your project management needs like managing Projects, Tasks, Defects, Incidents, Timesheets, Meetings, Appointments, Files, Documents, Users, Clients, Departments, ToDos, Project Planning, Holidays and Reports. It has simple yet efficient layout will make managing projects easier than […]
Groundnut oil is a popular choice⁤ for cooking⁢ in many households due to ‍its ⁤versatility and health benefits. However, it is important to ensure that the groundnut oil you are⁣ using is of high quality and purity. In this guide, we will discuss simple and practical ways to identify top-notch groundnut oil for cooking, including […]
Larimar ‍is​ a ⁣stunning blue gemstone found exclusively in the Dominican Republic, known for ⁤its remarkable spiritual and‌ healing properties as well as its beauty. This captivating stone has long been associated with inner peace, emotional balance, and tranquility due​ to its intricate patterns reminiscent of the ocean and its serene shades of blue. The […]
Larimar is a stunning⁤ blue gemstone‌ found exclusively in the Dominican Republic, known ⁣for its remarkable spiritual and healing properties as well as its beauty. This‌ captivating stone has​ long been associated with inner ​peace, emotional ‌balance, ⁤and ⁢tranquility due to its intricate patterns reminiscent of the ocean and its serene ​shades‌ of blue. The […]

Trending

Turquoise Jewelry is one of the ancient healing stones used for personal adornment and astrological benefits. The rare greenish blue-colored pectolite is celebrated for its enchanting powers among many crystal lovers. It is a hydrated phosphate of copper and aluminum that ranks 5 to 6 on the Mohs hardness scale. It is deemed a protective […]
24 March 2020, the evening when the Government of India ordered a nationwide lockdown for 21 days. Because the deadly Coronavirus crept into the world and turned it into a sinking ship, put unforeseen pressures on all of us with its destructive intentions. Soon after, it turned into a giant monster. Omicron, the new variant […]
Singapore is recognised globally as a prime destination for foreign investors. Its business structure is well-developed, and its tax system is favourable to business owners. The government has a strong support system for entrepreneurs and provides legal protection for intellectual property rights. All of these conditions create an environment that is ideal for Singapore company […]