Printing gridlines and row and column headings often makes it easier to read data in a large spreadsheet.
Follow these steps to add print gridlines as well as row and column headings to your spreadsheet.
1. Click on the Page Layout tab.
2. Check the Print box under Gridlines on the ribbon.
3. Check the Print box under Headings on the ribbon.
4. Click on the Print Preview button to preview your worksheet
before printing it. The gridlines appear as dotted lines outlining
the cells containing data in print preview.
The row numbers and column letters for those cells containing data will also be present along the top and left side of the worksheet in print preview.
To turn off this feature, go back into the Page Layout tab and “unclick” these options.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment