Excel Basics:
Setup Sheet
|
|
Excel Basics:
|
|
|
|
||
|
Spreadsheets can be really big. One way to print just exactly the cells that you want is with the Sheet tab in the Page Setup Dialog. To print only part of a sheet, you set a Print Area. Only cells in this Print Area will actually print, no matter what you see on your screen. You would want to use the Page Break Preview to manage printing several pages, but this dialog is good for smaller jobs. The Print Area could be the whole sheet, a range, a single cell, or even several ranges scattered over the sheet. Each separate range would print on a separate page. If you move the cells in the Print Area, the cell references for Print Area will change to show the new location(s). Handy dandy! |
|
Project 2: Excel Basics
Search Glossary Appendix |
Start with:
Open Page Setup | Sheet tab
Print Area: KeyboardThe Print Area is the cells which will be printed.
Print Area: MouseWhen you don't know the cell references, you can show Excel which cells you want to print by clicking or dragging in the sheet itself.
Clear Print AreaIf you don't want to restrict printing to your Print Area all the time, you need to clear out those cell references. There is an easy way!
Other sections of the Sheet tabLabels are the text that you typed into cells to explain what the rows and columns are about. If the Print Area won't fit on a single piece of paper, you will have one or more columns of data off on a page by itself. With no labels, this data won't make much sense. In the Budget sheet shown below, the column labels are in row 4 (months of the year) and the row labels are in column A (category names).
Page Order section:
The other option, Over, then down, prints the cells across the top of the sheet first and then moves down to print the next set of rows. |
||||||
|
~~ 1 Cor. 10:31 ...whatever you do, do it all for the glory of God. ~~ |
(budget.xls from the 
the Print Preview button on the toolbar.] How many pages will it take to print
this sheet?
If you opened
the Page Setup dialog from the Print Preview, some of your choices are not
available!
Click
on
the
Print Preview button. Not much will print! Only the cells in the
range that you typed, a1:d4, which is just the titles and some labels.
the Close button on the Preview window tool bar. Print Preview closes and you
are back in Normal view. The dialog closed, too. Your Print Area is
still a1:d4 and has a dashed border around it in Normal view now.
the 
Collapse Dialog
button at the right end of the Print Area text box. The dialog collapses to show just the text
box. The button changes to
the Restore Dialog button. The collapsed dialog will stay on top while you work in the spreadsheet itself. 
Close button, all your
changes in that dialog will be lost! You should always restore the dialog first and then click on the
OK button to
exit. (Unless, of course, you want to forget all about what you just did!)
You can
select non-adjacent cells and ranges. Their range cell references in the Print area text box
will be separated with a comma, like $E$3:$F$6, $G$15:$I:$89. Each range will
print on a separate page.
From the menu select 
Print Titles
section:
Print section:
The
default is Down, then over. This describes how Excel will
print the sections of a worksheet when it doesn't fit on one paper page -
from the top of the worksheet down the left, then move over and start at
the top again.
