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.

Free download for:
2019 2016 365 2013 2010 2007
Learn more
This tool is part of
Ultimate Suite
Flip Range for Excel 2019, 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 60-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 or 5 PCs
or 1 server
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.

This tool is part of Ultimate Suite
Read more about Suite

Supported versions

 

Excel

  • Excel 2019
  • 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
  • 32-bit and 64-bit
Buy now
  • Buy as part of Ultimate Suite
  • 60+ professional tools. No garbage.

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.

Your message was successfully sent.

Thank you for contacting us!
We will get back to you shortly.

You will receive a delivery confirmation for your message within a few minutes. If you don't get it, please re-send your message and make sure you entered a valid e-mail address.

Close