Selecting Multiple Worksheets in an Excel Workbook

We all know that to select one sheet in MS Excel, you simply click on the Sheet tab. The next logical question might be then, "How do I select several consecutive sheets at once"?

Well, there's an 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 hold down the Ctrl key and click on the sheet tabs as you need them.

Want to select all the sheets in the workbook?

Well, one way would be to use the Shift key trick. Another way would be to right click on a sheet tab and choose "Select All Sheets" from the pop up menu.

Well, that's it. It's a good skill to develop. You can use this trick for several different things, such as formatting multiple sheets simultaneously. Go ahead, give it a whirl!