Flip data in Excel vertically or horizontally

Elegant way to reverse columns and rows

Whether you need to flip a block of numbers, names, or letters, Flip Range for Excel will do it for you. Instead of writing different VBA codes to flip your table upside down or from left to right, reverse data order of columns or rows with a mouse click.

Learn more
This tool is part of
Ultimate Suite
Flip Range for Excel 2016 - 2007

With Flip Range you will

  • Reverse values verticallyChoose to mirror rows in Excel upside down.
  • Flip data horizontallyFlip columns in Excel left to right.
  • Transfer cell references correctlyKeep them unchanged or adjusted, or paste values only.
  • Choose to preserve original formatting of cellsDecide what to do with formatting if your tables have any.

Reverse the order of cells in Excel an easy way

  
Adjust flipping options as you need
Adjust flipping options as you need
See your flipped table in another worksheet
See your flipped table in another worksheet
Adjust flipping options as you need
See your flipped table in another worksheet

License benefits

Our customers get

Unconditional 30-day money-back guarantee
Secure payment
guarantee
Life-time license,
no additional fees ever
Volume discounts: the more you buy, the less you pay
1 license
for 2 computers
Free life-time support
Learn more
  • This tool is part of Ultimate Suite
  • 60+ professional tools. No garbage.
Buy now
  • Buy as part of Ultimate Suite
  • 60+ professional tools. No garbage.

These companies choose Ablebits products

   

Frequently asked questions

About Flip Range

  • What is Flip Range and what do I need it for?

    The tool flips data in Excel vertically or horizontally. You can choose to reverse the order of rows and columns in the entire worksheet or select a part of it for modification. In addition, the add-in lets you transfer the references correctly, keeps the formatting of current cells and backs up your original table.

  • Can't I just sort the values in Excel?

    To use the Sort option for this case you'll have to prepare your table: create a helper column/row, enumerate each cell according to a row/column number, select this additional range and the one you want to reverse, sort by helper range Largest to Smallest, and then delete the additional column/row. The task becomes more peculiar when you need to flip a part of a row or a column.

    With Flip Range you just select the range of interest and click Flip.

  • How to flip data in Excel with the Flip Range add-in?

    To reverse ranges in Excel, do the following:

    1. Run the add-in and choose to flip vertically or horizontally.
    2. Select your range.
    3. Decide what to do with cell references.
    4. See if you want to preserve formatting.
    5. Choose the option to create a backup copy.
    6. Click Flip.

    See a more detailed description here.

  • How many rows or columns can I flip at a time?

    The range to flip can contain as many rows and columns as you choose to reverse.

Supported versions

 

Excel

  • Excel 2016
  • Excel 2013
  • Excel 2010
  • Excel 2007
  • 32-bit and 64-bit
  • Desktop Excel included in Office 365
  • Desktop Excel included in Office 365 ProPlus

Windows

  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7
  • Windows Vista
  • Windows XP
  • 32-bit and 64-bit
Free download
14-day trial version
  • Included in Ultimate Suite for Excel
  • 14-day fully-functional version

Any questions or comments?

Please contact us here

Our working hours:
12:00 am - 10:00 am PST; 3:00 am - 1:00 pm EST; 8:00 am - 6:00 pm CET.
Excel add-ins and Outlook tools - Ablebits.com