How to flip data in Excel

Flip Range for Excel gives you two helpful tools: Vertical Flip and Horizontal Flip. With their help you can quickly reverse the order of rows, columns, and cells in a range.

Before you start

We care about your data and suggest you always create backup copies of your files. A special option of the tool will do that for you if you select it.

How to reverse the order of data in your table vertically or horizontally

Open the worksheet where you want to switch the order of your records, click the Flip icon in the Transform group on the Ablebits Tools tab, and select either Vertical or Horizontal Flip:
Click Flip on the Ablebits Tools tab and choose the way to reverse the data.

The tool's dialogue window offers the following settings:
Select the range and choose pasting option to transfer references correctly.

  1. When you need to select the entire table automatically, click the Expand selection icon.
  2. To select another data range, click the Select range icon and use the dialogue window to indicate it:
    Choose the range for each of two columns to interchange.

    Tip. You can also pick your range before running the tool.
  3. If you have any cell references in the selected range, adjust the way they will be pasted:
    • Choose to Adjust cell references to change them according to their new location after pasting.
    • Keep cell references to leave them intact.
    • Paste values only to delete cell references and have only the values inserted.
  4. If you have formatting you'd like to keep in the range you flip, select the Preserve formatting checkbox.
  5. Tick the Create a backup copy of the worksheet option to keep your original data.

Click Flip to see the selected data reversed in your Excel table.

Ask a question (posted publicly)

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.
Privacy policy Terms of use Contact us

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.

Ultimate Suite 2018.5 for Excel
60+ professional tools for Excel 2019-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard