Worksheets

Tips, Tricks, and Answers

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

Changing Worksheet Gridline Color
Want the gridlines in your worksheet to be a different color? You aren't limited to stodgy black; Excel lets you make them just about any color you want. Here's how to make the change.

Hiding Worksheet Tabs
Look at the bottom of a worksheet and chances are you will see tabs for all the worksheets in the current workbook. Want to hide those tabs? You can do so by using the steps described here.

Hiding Worksheets
Worksheets are easily accessible in a workbook, but you may not want them to be so open. You can hide worksheets so they aren't immediately visible, an then make them unhidden only when you need to work on them.

Running a Macro when a Worksheet is Activated
Need Excel to run a particular macro whenever a worksheet is selected? It's easy to do, as you'll discover in this tip.

Viewing Multiple Places in the Same Worksheet
Do you want to look at different places in the same worksheet at the same time? It's easy to do if you simply open new windows in Excel.

Viewing Multiple Worksheets at the Same Time
If you need to work on two worksheets in the same workbook at the same time, Excel makes this rather easy to do. All you need to do is display two windows and arrange them to both be visible.

More Information

The following are additional topics related to the subject of 'Worksheets'. A bracketed number after the topic indicates how many articles are related to that subject.