Insert Additional Worksheets

1. Choose Home> Cells> Insert> Insert Sheet. Excel automatically inserts a new blank worksheet on top of the currently selected sheet. Excel automatically assigns the next number - such as Sheet4.
2. Click a different worksheet tab. That worksheet becomes the current sheet.
3. When you add so many worksheets to a workbook that not all the sheet tabs are visible at any one time, and the sheet tab you want to click is not visible in the workbook. To deal with this problem, Excel provides Tab scrolling buttons in the bottom-left corner of the workbook that you can use to bring new sheet tabs into view.
   
   
   
   
4. Click the Next tab scroll button (with the triangle pointing right) to bring the next unseen tab of the sheet on the right into view. Hold down the Shift key while you click this button to scroll several tabs at a time.
5. Click the Previous tab scroll button (with the triangle pointing left) to bring the next unseen tab of the sheet on the left into view. Hold down the Shift key while you click this button to scroll several tabs at a time.
6. Click the First tab scroll button (with the triangle pointing left to the vertical bar) to bring the first group of sheet tabs, including the very first tab, into view.
7. Click the Last tab scroll button (with the triangle pointing right to the vertical bar) to bring the last group of sheet tabs, including the very last tab, into view.

Just don't forget that scrolling the sheet tab that you want into view is not the same thing as selecting it: You still need to click the tab for the desired sheet to bring it to the front of the stack.

To make it easier to find the sheet tab you want to select without having to do an inordinate amount of tab scrolling, drag the Tab split bar to the right to reveal more sheet tabs (consequently making the horizontal scroll bar shorter). If you don't care at all about using the horizontal scroll bar, you can maximize the number of sheet tabs in view by actually getting rid of this scroll bar. To do this, drag the Tab split bar to the right until it's smack up against the vertical split bar.

When you want to restore the horizontal scroll bar to its normal length, you can either manually drag the Tab split bar to the left or simply double-click it.

Going sheet to sheet via the keyboard

You can forget all about the darned Tab scrolling buttons and sheet tabs and just go back and forth through the sheets in a workbook with your keyboard. To move to the next worksheet in a workbook, press Ctrl+PgDn. To move to the previous worksheet in a workbook, press Ctrl+PgUp. The nice thing about using the keyboard shortcuts Ctrl+PgDn and Ctrl+PgUp is that they work whether or not the next or previous sheet tab is currently displayed in the workbook window.