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.
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.
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.
Waterfall Chart in Excel