• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Reorder Sheets in Excel

January 14, 2022 by Andrew Childress
How to fill Excel cells

As your Excel workbook grows, you'll need to do some housekeeping. That includes learning how to reorder sheets in Excel here's how.

A tool like Excel is all about making it easier to do data analysis and accomplish our workbook. If your workbook is disorganized, it’s bound to slow your work down and wipe out the benefit of a tool like Excel.

As your Excel workbook grows, you’ll need to do a bit of housekeeping. That includes learning how to reorder sheets in Excel so that it’s easy to navigate. Let’s learn how.

Reorder Sheets in Excel

You probably already know that each sheet shows as a separate tab at the bottom of an Excel workbook. When you click on a tab in the workbook, your active workspace will change and you’ll see new data.

To reorder sheets in Excel, click and drag on a tab at the bottom of the app. Drag-and-drop it to the desired position to rearrange the sheet order. Notice the arrow between the destination that shows where the sheet will end up.

Reorder sheets in Excel updated

When you change the order of sheets in an Excel workbook, nothing changes with the underlying data. You’re simply reorganizing the structure of the workbook.

Consider putting all of a “type” of sheets adjacent to one another, such as all of your inputs on sheets that are near each other in sequence. This type of organization helps you jump between sheets easily.

Reorder Multiple Sheets in Excel

Let’s say that your Excel workbook needs a more major rework. In that case, it helps to know how to reorder multiple sheets in Excel. Without much extra work, you can move multiple sheets at the same time.

Hold control on your keyboard (or command on macOS) and click on each tab to select multiple sheets at the same time. Then, click and drag to move those sheets together. All selected sheets are moved together and will end up between the selected sheets.

Reorder multiple sheets in Excel updated

Remember: take time to clean up your Excel workbook before you send and share it. Small tweaks like reordering sheets are sure to help your user work efficiently.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post: « Right click insert cells Excel Insert New Cells in Excel
Next Post: Insert Sheet Rows in Excel Delete sheet rows in Excel »

Sidebar

Recent Posts

  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel
  • EXACT in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

  • Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top