This site has limited support for your browser. We recommend switching to Edge, Chrome, Safari, or Firefox.

How to Reorder Multiple Sheets in Google Sheet

Want to reorder multiple sheets within one Google Sheet file? If you are only reordering a few sheets, all you need to do is to drag them around one by one. You can also do this if you are intending to reorder a large number of sheets, but it can get tedious after a while. There may be an easier way using a few keyboard shortcuts.


Step 1: Multi-Select the Sheets You Want to Reorder

To select multiple sheets together that you want to reorder, click on one sheet, and then press on Shift + click on another sheet to select all sheets contained in between.

For example, as shown in the screenshot below, to select Sheet8, Sheet9, and Sheet10 altogether, you can click on Sheet10, and then press on Shift while clicking Sheet8. You can also do it the other way around; you can click on Sheet8 and then Shift + Sheet10.

Step 2: Shift + Drag to Move the Selected Sheets

To drag the selected sheets all in one go, click Shift and drag them to wherever you want to place them.

For example, to place Sheet8, Sheet9, and Sheet10 just after Sheet2, click Shift and drag the selection to a position after Sheet2.

This is a good way to reorder multiple sheets all at once instead of dragging Sheet8 after Sheet2, then Sheet9 after Sheet8, then Sheet10 after Sheet9. Itโ€™s doable if there are only a few sheets, but if you are moving 30 sheets this way, it can get tedious and time-consuming.

Hope this helps!


Hi, I'm Ryan.

Over the past 10 years, I've lived & worked in 5 cities across 3 countries.

I like helping others to move abroad, and helping them to decide whether they should.

MY VISA GUIDE โ†’

Spark a Conversation

Cart

No more products available for purchase