Arrow left
Back to product guides
Google Sheets Tips

How to Move Tabs in Google Sheets

In this article, we will describe how to reorder tabs in Google Sheets.

How to change the order of tabs in Google Sheets

There are two ways to change the order of sheets in Google Sheets.

The first approach is to change the order of adjacent sheets.

  1. Point a tab you want to move with your cursor.
  2. Right-click and select “Move right” if you want to change the order of the tab and the right tab, or choose “Move left” if you need to switch the order of the tab and the left tab.

The second way is more flexible and helpful when you have more than a couple of sheets.

  1. Point a tab you want to move with your cursor
  2. Hold the left click down, and drag the tab to the place you want to move it to
  3. Drop the tab at a destination
How to Move Tabs in Google Sheets

 

How do you sort a worksheet tab in alphabetical order in Google Sheets?

Unfortunately, with the default setting of Google Sheets, you can’t sort a tab in alphabetical order. We suggest you move a tab to the proper position every time you insert it. If each worksheet contains a relatively small amount of information and data, you can consider gathering information in a sheet and sorting the information in alphabetical order there.

 

How do you reverse the order of sheets in Google Sheets?

As the same as above, you need to reverse the order of sheets manually. It depends on how many sheets you have in a Google Sheets file, but unless you have too many sheets (e.g., 50), it is still manageable to reverse the order of sheets manually, as what you need to do is relatively simple. For instance, you can move the rightmost sheet next to the leftmost one to the left and then bring the rightmost one (initially the second one from the right) next to the leftmost one (originally the rightmost one) to the right. Enjoy!

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at: founders@liveflow.io
Check Icon
Call us at +1 (415) 650-1711