Microsoft Office Tutorials and References
In Depth Information
Using the View Context Tab to Show and Hide Basic Screen Elements
prefix is Excel’s way of declaring that this range is not C11:C15 on Sheet1, in which the
function has been written.
Again, the range referenced between
’s parentheses is on Sheet2, and that
Using the View Context Tab to Show and Hide Basic
The Excel worksheet features a number of characteristics that are so basic you probably
don’t even think about them—namely, the gridlines that demarcate each cell, and the
row and column headings that help you identify cell addresses. But if you want, you can
remove these elements from the worksheet (though of course you can always return
them to the screen when you want).
So why would you want to do this? After all, the cell gridlines and row and column
headers help you line up cells visually. The answer to the question, then, is
presentational. Once you’ve completed a worksheet and finished your design work and
formula-writing, and you need to show it to others, eliminating the gridlines and headers
imparts a cleaner look to your data. Compare the two views shown in Figure 9–24.
Figure 9–24. The same worksheet, with and without cell gridlines and row and column headers
Turning these elements off and back on is easy. Just click the View tab, and click Gridlines
and/or Headings in the Show button group (see Figure 9–25).
Figure 9–25. Show and tell: Where to turn gridlines and headings on and off
Just uncheck the boxes to turn the features off, and check the boxes again to turn the
features back on. And as you see, you can even hide the formula bar, too.