|
Printing
First move to cell A1.
All of the Windows spreadsheets try to figure out what
you want to print. Sometimes they're right,
sometimes they're wrong. So........
The most important thing with printing is to tell the printer
what to print.
Unlike a word processor, you may need to highlight
what you want to print. So, point to cell A1,
hold down the left mouse button and drag down
and to the right to cell G25.
You've highlighted the entire spreadsheet. It should look
like the image below.

Now click-on File in the Menu Bar and then click-on Print
in the drop-down menu. The following window should appear:
If we’re really sure of what we’ve done, then Active
sheets(s) is OK. However, if you make a mistake
somewhere in the spreadsheet, you might end up printing a lot of
extra pages. Notice in the "box" that indicates Print
what that there are three selections: Selection, Active
sheet(s), and Entire Workbook. So, as indicated above, point to
the "circle" in front of Selection
and click the left mouse button.
It's usually a good idea to see what our printout will
look like. So, point to Preview. Click the left button. A
picture of what our printout will look like appears – similar to
the one below.
First notice that an "image" of your spreadsheet
appears. In the top left corner of the screen you will see the words
Next and Previous. In this case they are not active.
If our spreadsheet had been larger than one page, then you
would see these "activated" and a "page count"
would appear at the bottom left of your screen. So, this spreadsheet
will print on one page in "portrait". Go ahead and
click-on Print. When the printer completes the print, label
this printout "portrait default".
When you click Print, your Preview screen will disappear.
To continue with printing, repeat the instructions
for printing on the last page again – File –
Print – click in Selection circle – Preview. Your screen
above should appear again.
Now click-on Setup in the top button Bar (see arrow
above).
Notice that the Page Setup screen indicates that
you are in Portrait view. Now we’ll enhance the
spreadsheet to make it a bit more presentable. In the Orientation
area click-in the small circle in front of Landscape.
The spreadsheet will now print on the page as indicated. Next, in
the Scaling area, click-in the box to the left of % normal
size. With either the "up/down" triangles, or
by typing in the information, change the size to 125.
Then click-on OK. Your spreadsheet will now be larger and
fill the paper more appropriately. Click-on Print and when
this spreadsheet comes out of the printer label it: "landscape
– enlarged to 125 %". Go ahead and adjust the
"size" of your spreadsheet so that it becomes too large
to fit on a single page. Set the Scaling to 200 and
click-on OK. When you return to the Preview screen, the Next
and Previous buttons at the top will now be active,
and you’ll see 1 of 3 or 4 pages in the lower left
corner of the screen. Then click-in the small circle to
the left of Fit 1 page(s) wide by 1 tall in the Scaling
area and make sure that 1 page is set. Excel will now return
your spreadsheet to one page. Try other things here. Work
with margins, etc. Any time you desire to print, go ahead and do so.
This will give you a feel for how the spreadsheets will print. When
you are finished, simply click-on Close and you will return
to your spreadsheet.
Now we'll call it a day and get out of Excel for Windows. First,
let's save our work one more time. If you forget, Excel
will remind you to do it. What a nice program!!
Point to the Edit menu and click the left button. Point to
Exit. Click the left button. That's it for now.
When you return, we'll retrieve our work and do some really neat
graphics. To open your spreadsheet again follow the instructions on
pages 10 and 11.
|