Move a Worksheet

Moving Excel Worksheets

Opening an Excel workbook displays Sheet1 as the first sheet ready for data. You put another page of information on Sheet2, and add more information to Sheet3. You realize after several sessions that you do more work in Sheet2 than Sheet1. You would like the workbook to open and display Sheet2 ahead of Sheet1 and Sheet3. What do you do. You move it!

You can change the order of worksheets using the Move or Copy command or the Drag and Drop technique.

Using the Move or Copy command

To use the Move or Copy command, put the mouse pointer over the sheet name, right-click on the tab and choose the Move or Copy command. Inside the Move or Copy dialog box, you will see a box label Before sheet:. To move Sheet1 in front of Sheet3, select Sheet3 in the dialog box. Press the OK button. Sheet1 has moved before Sheet3.

Using Drag and Drop

An easier way is to Drag and Drop with the mouse. Put the mouse over the Sheet1 tab, hold the mouse button down, and move the mouse between Sheet2 and Sheet3. Release the mouse button. Sheet1 is now in between Sheet2 and Sheet3.

Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.

Post Footer automatically generated by Add Post Footer Plugin for wordpress.