Gridlines and Headings of a Worksheet

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

The Gridlines and Headings of a Worksheet

Showing the Gridlines of Cells

To show the limits of a cell, it displays borders around it. These borders are also referred to as gridlines. If you want, you can show or hide the gridlines.

To hide the gridlines of cells of a worksheet, on the Ribbon:

  • Click Page Layout. In the Sheet Options section, under Gridlines, remove the check mark on View:

  • Click View. In the Show/Hide section, remove the check mark on the Gridlines check box

Gridlines

To show the gridlines again:

  • In the Sheet Options section of the Page Layout tab of the Ribbon, under Gridlines, put a check mark on the View check box
  • In the Show/Hide section, of the View of the Ribbon, click the Gridlines check box

Practical Learning Practical Learning: Hiding the Gridlines

  1. Click the Request For Time Off tab
  2. On the Ribbon, click View
  3. In the Show/Hide section, click the Gridlines check box to uncheck it
     
  4. Click the Tuition Reimbursement tab
  5. Press and hold Ctrl
  6. Click the Time Sheet tab
  7. On the Ribbon, click Page Layout
  8. In the Sheet Options section, under Gridlines, click the View check box
  9. Save the file

Showing the Headings of a Worksheet

We were introduced to columns in Lesson 2 and to rows in Lesson 3. We also saw the columns start in the top section by column headers and the rows start on the left by row headers. The column headers and the row headers are characteristics of a worksheet. This means that you can show or hide the column headers or the row headers for a worksheet while the headers are hidden or shown for another worksheet.

By default, the column headers and the row headers display on their worksheet. To hide the headers:

  • On the Ribbon, click View. In the Show/Hide section, remove the check mark on the Headings check box:

Headings

  • Click Page Layout. In the Sheet Options section, under Headings, remove the check mark on View:

To show the headers again:

  • In the Show/Hide section, of the View tab of the Ribbon, click the Headings check box
  • In the  the Sheet Options section of the Page Layout tab of the Ribbon, click the Headings check box

Practical Learning Practical Learning: Hiding the Gridlines

  1. Click the Request For Time Off tab
  2. Press and hold Shift
  3. Click the Time Sheet tab
  4. On the Ribbon, click View
  5. In the Show/Hide section, click the Headings check box to uncheck it
     
    Headings
  6. Click the Tuition Reimbursement tab
  7. Click the Request For Time Off tab
  8. Save the file