172k views
3 votes
do the worksheet gridlines appear by default when printed? if not, can you instruct excel to print them? how?

User Xearinox
by
8.8k points

1 Answer

2 votes
By default, the worksheet gridlines in Excel do not appear when you print a document.

However, you can instruct Excel to print the gridlines along with the data by following these steps:

1) Open the Excel worksheet you want to print with gridlines.

2) Click on the "Page Layout" tab in the Excel ribbon.

3) In the "Sheet Options" group, check the box labeled "Print" under the "Gridlines" section.

4) Once you've enabled the "Print" option, the gridlines will appear on the screen to give you a preview of how they will look when printed.

5) Adjust any other print settings as needed, such as page orientation, margins, and scaling.

6) Finally, click on the "Print" button to print the worksheet with the gridlines.

Enabling the "Print" option for gridlines ensures that they will be included when you print the worksheet.
User Gsiems
by
8.2k points