Page Layout -> Sheet Options

Page Layout: Sheet Options

When you look at a spreadsheet on a computer you see the Headings for the Rows and Columns. You also see the gridlines. You can print your spreadsheet the same way.

 

1. Try This: Edit the Sheet Options

Go to Page Layout->Sheet Options.

 

What Do You See? There are check marks to print the Gridlines as well as the Headings.

 

2. Try This, Too: More Sheet Options

When you click on the Option arrow in the bottom right corner of the Sheet Options group you will return to the Sheet tab in the Page Setup Summary.

 

OK. Sheet options...almost done with the Page Layout options.

 

Exam 77-882: Microsoft Excel 2010 Core

3. Formatting Cells and Worksheets

3.3. Create row and column titles: Print Row and column Headings