Page 140 - Excle-En-V3

6- After you select the option which you want, you can click “print” Button.

26.1 - Controlling the printing of grid lines and column and row headers or titles:
The printing of gridlines, headers, and headings of columns and rows,

and not just their display on the screen as we previously knew, was
controlled. This is done from the “Page Layout” tab, then from the sheet
options, we put “True” in front of Print under the gridlines to print it, and
we put true in front of Print under the headings to print it, as well.

Figure 207: printing of gridlines and row and column headings

The output is as follows:

Figure 208: Implementing the printing of gridlines and row and column heading

26.2- Scaling Print No Scaling select Proper Scaling
File tab

1- Fit Sheet on One Page
2- Fit All Column on One Page
3- Fit All Rows on One Page
4- Custom Scaling Options

132 Central Unit for Information Technology Training - Supreme Council of Universities © Intellectual Property Rights 2024