Selecting Multiple Worksheets in an MS Excel Workbook

Selecting Multiple Worksheets in an MS Excel Workbook

We all know that to select one sheet you simply click on the sheet tab. The next logical question might be “How do I select several consecutive sheets at once?”

Easy enough answer. First, you’ll need to locate the worksheet tabs in order to select the ones you want.

Then, simply select the first sheet by clicking on its tab then hold down the Shift key and click on the last sheet you want to select. You should notice that all the tabs between the two have also been highlighted.

What if the sheets you need to select aren’t consecutive? Easy as pie. All you need to do is to hold down the control key and click on the sheet tabs as you need.

Want to select all the sheets in the workbook?

Well, one way would be to use the shift key trick. Another way would be right-clicking on a sheet tab and selecting the Select All Sheets choice from the pop-up menu.

Well, that’s it. It’s a good skill to develop. You can use this trick for many things such as formatting multiple sheets simultaneously and today’s Tip of the Day. Go ahead, give it a whirl!