lpl2023季后赛,LOL游戏CB巴西锦标赛外围分析网站|LOL游戏中国赛程中心

Flip 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. On the Ablebits Tools tab, in the Transform group, click the Flip icon, and select either Vertical or Horizontal Flip:
Click Flip on the Ablebits Tools tab and choose the way to reverse the data.

In the dialogue box that pops up, configure 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. To keep the formatting in the range you flip, select the Preserve formatting checkbox.
  5. Tick the Back up this worksheet option to keep your original data.

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