MS Excel - Checking Print Area
Dakota Kuhel
|
19 steps
|
33 seconds
1
Open the File you wish to modify.
2
Click "File Tab"
3
Click "Print"
4
In this Print Preview we can see that we are missing some data from the sheet.
5
Click "Back"
6
Click the "Page Layout" Tab
7
Click the "Drop Down Button" to the left of the formula bar. This list shows you any "Named Ranges" in the Spreadsheet.
8
Click "Print_Area". The Print Area is saved as a Named Range, so we will be able to see what it is by clicking here.
9
Now we can see what is defined as the named range. In this case, it is cells A1:G17. That means that anything not in cells A1:G17 will not be printed.
10
To modify the Print Area, highlight the cells or columns you wish the new Print Area to be. I suggest selecting by using the columns. That way if you add more rows to your sheet, you do not need to modify the Print Area each time.
However, if you add a new column that you wish to be printed, you will need to follow these steps again to include that column.
11
Once you have your selection, click "Print Area", then click "Set Print Area".
12
Now your new Print Area has been set.
13
We can verify by clicking the "Drop Down Button" to the left of the formula bar.
14
Click "Print_Area"
15
Now we see our new Print Area.
16
To check it in the Print Preview, click "File Tab"
17
Click "Print"
18
If the preview does not show, click "Show Print Preview"
19
Here we can see that our form now shows all populated lines.
