Topic: Worksheet Tabs

The following articles are available. 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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Naming Tabs for Weeks A common structure in workbooks is for each worksheet to contain information for a specific week in the year. This tip provides two macros you can use to automatically name worksheets for the various weeks in a year. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Tips, Tricks, and Answers

Perplexed by Pivots?

Helpful Links

Great Info!

RSS Feeds