140
22
33
44
11
2
Click the Home tab.
3
Click the Delete .
4
Click Delete Sheet.
•
You can also right-click the tab
and then click Delete Sheet.
1
Click the tab of the worksheet
you want to delete.
Delete a Worksheet
If you have a worksheet that you no longer
need, you can delete it from the workbook.
This reduces the size of the workbook, reduces
clutter in the worksheet tabs, and makes the
workbook easier to navigate.
It is important to note that you cannot undo a
worksheet deletion. Therefore, it is always a
good practice to check the worksheet contents
carefully before proceeding with the deletion.
If the worksheet contains any data you need
but you still want to remove the worksheet, cut
or copy the data and paste it into another
worksheet.

142
22
33
11
3
Click Options.
1
Click the tab of the worksheet
you want to customize.
2
Click the File tab.
Change the Gridline Color
You can add some visual interest to your
worksheet by changing the color that Excel uses
to display the gridlines. The default color is
blank, but Excel offers a palette of 56 colors
that you can choose from.
Changing the gridline color also has practical
value because it enables you to differentiate
between the gridlines and the borders that you
add to a range or a table.
Change the
Gridline Color
09_577639-ch07.indd 14209_577639-ch07.indd 142 3/15/10 2:44 PM3/15/10 2:44 PM
143
Manipulating Excel Worksheets
CHAPTER
7
44
66

09_577639-ch07.indd 14309_577639-ch07.indd 143 3/15/10 2:44 PM3/15/10 2:44 PM
144
22
33
11
•
Excel turns off the gridline
display.
Turn Gridlines On
•
To turn the gridlines back on,
click Gridlines (
changes
to
).
Turn Gridlines Off
1
Click the tab of the worksheet
you want to work with.
2
Click the View tab.
3
Click Gridlines ( changes
to
).
Toggle Worksheet Gridlines On and Off
You can make your worksheet look cleaner and
make the worksheet text easier to read by
turning off the sheet gridlines. When you do
this, Excel displays the worksheet with a plain