How To Flip A Set Of Data In Excel

How to quickly flip data upside down in Excel?

In some special cases, in the Excel work, we may want to flip our information upside downward, which ways to reverse the order of a cavalcade data every bit below screenshot shown. If you type them one by one in a new social club, this will be time-consuming. Here I innovate some quick means to flip them upside down in a short fourth dimension.

Flip data upside down with help cavalcade and Sort

Flip data upside downwards with formula

Flip data upside down with Kutools for Excel

You tin create a help column besides your information, then sort the assist column to help yous contrary the data.

i. Click at a prison cell adjacent to your showtime data, and type 1 into it and go down the side by side cell type 2. Encounter screenshot:
doc filp upside down 2

2. Then select the number cells and drag the autofill handle down until the number of cells is aforementioned every bit the number of information cells. Come across screenshot:
doc filp upside down 3

iii. Then click Data > Sort Largest to Smallest. See screenshot:
doc filp upside down 4

4. In the Sort Alert dialog, check Expand the selection, and click Sort. See screenshot:
doc filp upside down 5

Now both help column and data cavalcade are reversed in order.
doc filp upside down 6

Tip: You tin remove the help column if yous practice non need it any more.

If you are familiar with formula, hither I can tell you a formula to reverse the order of a column data.

one. Select a bare jail cell and type this formula =Alphabetize($A$1:$A$8,ROWS(A1:$A$eight)) into it, press Enter central, then drag the autofill handle to fill this formula down until there appears indistinguishable order information. Come across screenshot:

doc filp upside down 7

doc filp upside down 8

At present the data has been flipped upside down, and you tin can remove the repeat data abroad.
doc filp upside down 9

With above methods, you only tin can reverse the values order. If yous want to reverse the values with their jail cell formats, yous can use Kutools for Excel'southward Flip Vertical Range utility. With Flip Vertical Range utility, y'all can cull flip values only or flip values and cell format together.

After costless installing Kutools for Excel, y'all just need to select the data, and click Kutools > Range > Flip Vertical Range, and so specify one flipping type in the submenu every bit yous need.
excel add in tool for reversing rows data vertically

If you specify the Flip All:
doc filp upside down 11

If y'all specify the Only flip values:
doc filp upside down 12

With Kutools for Excel, you can reverse the order of a row without format or keeping format, you can swap two uncontinuous ranges and then on.

The All-time Role Productivity Tools

Kutools for Excel Solves About of Your Bug, and Increases Your Productivity by 80%

Reuse: Chop-chop insert complex formulas, charts and annihilation that you accept used before; Encrypt Cells with password; Create Mailing List and send emails...
Super Formula Bar (hands edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
Merge Cells/Rows/Columns without losing Data; Carve up Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
Select Indistinguishable or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Detect in Many Workbooks; Random Select...
Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Cheque Boxes and more...
Extract Text, Add Text, Remove by Position, Remove Infinite; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
Super Filter (save and use filter schemes to other sheets); Advanced Sort by month/week/twenty-four hours, frequency and more than; Special Filter by assuming, italic...
Combine Workbooks and WorkSheets; Merge Tables based on cardinal columns; Divide Data into Multiple Sheets; Batch Catechumen xls, xlsx and PDF...
More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Like shooting fish in a barrel deploying in your enterprise or organization. Total features thirty-mean solar day gratis trial. 60-24-hour interval money back guarantee.

kte tab 201905

Function Tab Brings Tabbed interface to Part, and Make Your Work Much Easier

Enable tabbed editing and reading in Discussion, Excel, PowerPoint , Publisher, Access, Visio and Project.
Open and create multiple documents in new tabs of the same window, rather than in new windows.
Increases your productivity past fifty%, and reduces hundreds of mouse clicks for you every day!

officetab bottom