How to move non-adjacent worksheets together in Excel

When working with large Excel workbooks, it is common to have dozens or even hundreds of worksheets. Over time, worksheets that belong together, such as monthly reports, department data, or project sheets, may become scattered throughout the workbook. This can make navigation more difficult and slow down your workflow when you need to locate or organize related worksheets. In such cases, quickly grouping related worksheets together can greatly improve workbook organization and navigation. This tutorial will show you two methods to move non-adjacent worksheets together in Excel.

• Manually move scattered worksheets together manually
• Quickly move scattered worksheets together in one click by Kutools

Manually move scattered worksheets together

Excel allows you to select multiple worksheets at the same time by holding the Ctrl key and clicking individual sheet tabs. However, efficiently moving non-adjacent worksheets so they are grouped together is not always straightforward, especially when dealing with workbooks that contain many sheets. In this section, you will learn how the built-in method works can help you manage worksheets in smaller workbooks.

Suppose your workbook contains the following worksheets:

You may want to group the monthly worksheets together so they appear in order:

Step 1: Select non-adjacent worksheets

First, you need to select the worksheets you want to move.

1. Press and hold the Ctrl key on your keyboard.
2. Click each worksheet tab that you want to select.
   Excel will highlight all selected worksheets, indicating that they are grouped together temporarily.

   

Step 2: Drag the selected worksheets

After selecting multiple worksheets:

1. Click and hold one of the selected worksheet tabs.
2. Drag the group of worksheets to the desired location in the workbook.
3. Release the mouse when the insertion indicator appears where you want the sheets to be placed.

   

Result

Once you release the mouse, the selected worksheets will be moved together to the new position.

This method works for basic worksheet organization tasks and can help you rearrange sheets when the workbook structure is relatively simple. However, when a workbook contains many worksheets, finding specific sheets among dozens of sheet tabs can take time. Dragging worksheets to the desired position can also be difficult because the sheet tab area is limited and often requires repeated scrolling to locate the correct placement. To overcome these limitations, a more efficient worksheet management tool can be extremely helpful. This is where Kutools for Excel's Navigation Pane provides a much easier solution.

Quickly move scattered worksheets together in one click by Kutools

Kutools for Excel provides a powerful Navigation Pane that allows you to manage worksheets more efficiently. Instead of scrolling through sheet tabs at the bottom of Excel, the Navigation Pane displays all worksheets in a convenient panel where you can easily view, select, and organize them.

With the Move the non-adjacent worksheets together option, you can quickly reorganize scattered worksheets and move them together with much less effort. This feature is especially helpful when working with large workbooks that contain many sheets.

Step 1: Open the Navigation Pane

After installing Kutools for Excel, go to the Kutools tab in the Excel ribbon. Click Navigation.

Step 2: Select Multiple Worksheets

The Navigation Pane will appear on the left side of the Excel window, displaying a list of all worksheets in the current workbook.

In the Worksheet & Workbook panel of the Navigation Pane:

1. Hold the Ctrl key.
2. Click the worksheets you want to move. You can select multiple worksheets even if they are separated by many other worksheets.

   

Step 3: Enable "Move the non-adjacent worksheets together"

After selecting the worksheets, expand the first drop-down list menu above the worksheet list, then select Move the non-adjacent worksheets together.

Result

Once the operation is completed, all selected worksheets will be automatically moved together in the workbook.

Conclusion

Moving non-adjacent worksheets together is a common task when organizing large Excel workbooks.

While Excel allows selecting and dragging multiple worksheets, managing scattered sheets can quickly become inefficient.

Compared with Excel’s manual method, Kutools for Excel allows you to:

• locate worksheets more easily
• select scattered worksheets faster
• organize worksheets more efficiently

This makes worksheet management much faster and more convenient, especially when working with large or complex workbooks.

Related articles

• How to search worksheets by name in Excel?
  This article provides two methods to help you easily search worksheets by name in Excel.
• Toggle between the previous and last sheets back and forth in Excel
  This article provides two methods to help you efficiently switch between the previous and last worksheets in Excel.