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

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

How to Move Worksheets in Excel

August 10, 2021 by Andrew Childress

There's a natural flow to how we read documents. After all, we're trained to read content form left to right. Let's learn how to move worksheets in Excel. 

There’s a natural flow to how we read documents. After all, we’re trained to read content form left to right. Yet, too many Excel users arrange data across worksheets in a seemingly random sequence. The good news is that it’s never too late to tidy up your Excel workbooks! Let’s learn how to move worksheets in Excel. 

How to Move Worksheets in Excel

Should you move worksheets in Excel? I think the answer is a definite “yes” so that it’s easy to use your workbook. My suggested setup for an Excel workbook is to place your summary tabs on the left side of the workbook, and your backing data on the right side. Since we tend to read documents from left to right, it’s best to have summaries as your leftmost tabs.

Keep in mind that moving worksheets doesn’t change them in any way. It won’t break your formulas or disrupt how the workbook performs.

When you’re ready to move worksheets in Excel, turn your attention to the bar at the bottom of the app. Then, just drag-and-drop the tab to a new position to re-arrange it in the workbook.

Move worksheets Excel

That’s it! Just drag-and-drop to place your Excel worksheets into the easiest possible format. Always spend time organizing before you press send.

How to Move Multiple Worksheets in Excel

Let’s say that you have a massive workbook with countless worksheets. It’s certainly possible to find yourself with dozens of sheets in complex workbooks. In those cases, it really helps to know how to move multiple worksheets at the same time.

To do that, hold Control on your keyboard (or Command on macOS) and click on multiple worksheets. Then, follow the same process to drag-and-drop the sheets to a new spot in the workbook. Both sheets will move, and be placed side-by-side.

Move multiple worksheets Excel

Remember: a bit of extra time arranging your workbook helps you to keep it clean and easy to navigate. That helps both you, the workbook maintainer, and the workbook user.

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

About Andrew Childress

Previous Post:Waterfall chart in ExcelWaterfall Chart in Excel
Next Post:How to Apply a Cell Style in ExcelHow to apply a cell style in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows 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
  • 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