Hampden-Sydney College | Academic Computing
Wednesday, November 19, 2008
  TECHNOLOGY
 
  Blackboard
  Blackboard Help
  Faculty Awards
  Software Downloads
  Software Tutorials
  Teaching Links
  Technology Lunch Table

  H-SC HOME
 
  Academics
  Admissions
  Alumni
  Athletics
  Blackboard
  Bookstore
  Calendar
  Commencement
  Computing Center
  E-mail Online
  Financial Aid
  Fitness
  Instr Technology
  Leadership Center
  Library
  Making A Gift
  News
  Parents
  Paying for College
  Search
  Site Index
  Student Life
  Visiting HSC

  CONTACT US
 
  Students
  Faculty & Staff
  Faculty Profiles
  Staff Profiles
  Job Openings

 
   INSTRUCTIONAL TECHNOLOGY

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.

 

 

 

Up ] Starting Excel 2000 ] Moving Around the Spreadsheet ] Widening Columns ] Inserting Rows ] Aligning Cells ] Saving and Exiting Spreadsheets ] Retrieving Spreadsheets ] Adding Numbers ] Function Pasting ] AutoSum function and Subtraction ] More Cell Formatting ] New Page 3 ] Division and Percent ] Copying ] Entering Formulas in Monthly Totals ] Absoluting ] [ Printing ] Highlighting Multiple Ranges ] Graphics ] More Graphics ]


© Copyright 2007 H-SC | Site Index | E-mail a link | Hampden-Sydney College, Hampden-Sydney, VA 23943 | 434-223-6000 | webmaster@hsc.edu