How to Modify Page Setup in Excel
- |
- 18 steps |
- 2 minutes
1
Click "Page Layout"
Change the Margins
2
Click "Margins"
3
Either select a pre-made set of margins or choose "custom margins"
4
Selecting "custom margins" will open a window with multiple editing options including margin sizes on each side of the paper, whether the sheet should be centered horizontally or vertically on the page, and print preview using the custom margins changes.
5
Click "print preview" to see how the changes made will impact the print view.
6
This page will pop up when you select "print preview". To return to the previous page to make changes, click the arrow in the upper left hand corner.
Page Orientation
7
In the "Page Layout" tab, click "Orientation"
8
You can now select either portrait or landscape.
Change Sheet Size
9
In the "Page Layout" tab, click "Size"
10
This will open a drop down menu where you can select the size of the paper you will be printing on to adjust the sheet size. Standard is letter size 8.5" x 11".
Print Tiles
11
Under the "Page Layout" tab, click "Print Titles" to select which rows and columns will repeat on each printed page of the sheet.
12
Click the arrow next to "Rows to repeat at top:" to return to the sheet to select which rows you would like to repeat each time the sheet prints a new page.
13
For this example, we select row 1 which holds the table headers.
14
Click the arrow next to "Rows to repeat at top:" to return to the editing window.
15
Click "OK" to finish selecting the rows you would like to print at the top of each sheet.
