Change the Order of Tabs in Excel

Add to Favorites

How to change the order of the tabs in your spreadsheet.

This is rather easy to do and makes your spreadsheets much easier to follow and understand.  There are two ways to change tab order in Excel, and both are explained below.

Method 1 - Change Order of Tabs

This is the easiest method when you have only a few tabs in the workbook.

  1. Left-click and hold the mouse button until you see a little black arrow appear next to the tab and your mouse pointer should have a small "page" icon under it (this icon didn't come through on the screenshot below).
  2. Then, simply drag the sheet tab to whichever position you want.

    You will see the small black arrow move with your mouse to show you where the tab will be placed.
  3. Let go of the mouse button where you want the tab to be placed and that's it.

This is the easiest method when you have only a few sheets in the workbook. If you have many worksheets, the next method will be easier.

Method 2 - Change Order of Tabs

This method is the best for when you have a lot of tabs in your worksheet.

  1. Right-click the tab you want to move and then select the option Move or Copy...

  2. On the small window that opens, select the sheet BEFORE WHICH you want the current worksheet to be moved.  If I select Sheet3, then my sheet will be moved in front of Sheet3.
  3. Hit OK and that's it.


Ordering your sheets is very important when you have a lot of data and you need to send it out to someone.

You can also change the color of the tabs in Excel to better organize them.

Don't forget to download the accompanying spreadsheet for this tutorial.

Downloadable Files: Excel File

Question? Ask it in our Excel Forum

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Quickly Add, Edit, & Manage Business Specific Diagrams in Excel (SmartArt)
Tutorial: In this tutorial I am going to show you how to add, edit, and manage Business oriented dia...
3D References - Formulas that Reference Multiple Sheets at Once in Excel
Tutorial: Have one simple formula that will reference the same cell or range of cells on multiple w...
Combine Multiple Chart Types in Excel to Make Powerful Charts
Tutorial: In this tutorial I am going to show you how to combine multiple chart types to create a si...
Change the Name of a Chart in Excel
Tutorial: How to change the name of a chart in Excel. This allows you to use a more intuitive char...
Sort on Multiple Columns at Once in Excel
Tutorial: How to sort a data set by multiple columns in Excel.  This allows you to better organize ...
Increment a Value Every X Number of Rows in Excel
Tutorial: (New Easier Version for Excel 2010 and Later) How to increment a value, number, percent, e...