Worksheet Tabs

Tips, Tricks, and Answers

The following articles are available for the 'Worksheet Tabs' topic. Click the article's title (shown in bold) to see the associated article.

Dynamic Worksheet Tab Names
Would it be helpful if your worksheet tab names were determined by the contents of a cell in your worksheet? Using the macros described in this tip, you can easily make the worksheet tabs just as dynamic as any other part of an Excel worksheet.

Freezing Worksheet Tabs
It is possible for your workbooks to contain scores of worksheets. If you want to repeatedly jump back to a specific worksheet, navigating those sheets can sometimes get tedious. This tip discusses what you can do to make that navigation to a single worksheet easier than ever.

Getting the Name of the Worksheet Into a Cell
Excel allows you to change the names assigned to the worksheets in a workbook. If you want to have those names appear in a cell on the worksheet, there are a couple of ways you can approach the problem. Here's an assortment of techniques.

Increasing Font Size In Worksheet Tabs
While Excel does not have an intrinsic way to change the font in on a worksheet tab, Windows does.

Naming Tabs for Weeks
Need to set up a workbook that includes a worksheet for each week of the year? Here's a couple of quick macros that can do the hard work for you.

Picking Worksheets Quickly
Worksheet tabs are the quickest way to select worksheets, unless you have so many worksheets that you can't see all the tabs at once. This tip explains how you can more easily select from a large number of tabs in a a workbook.

Referencing Worksheet Tabs
Ever want to use the name of a worksheet tab within a cell? Here's how you can access that information using the CELL function.

Sheets for Days
Need a quick way to have a worksheet for each day in a month? Here's a macro that makes the worksheet creation a snap.

Turning Off Worksheet Tabs
Worksheet tabs are a great way to jump from sheet to sheet in a workbook. You may, however, want to turn them off (hide them) so that they cannot be seen by users. This tip explains how.