Happy Computers Essentials Guide to

Seeing More Of The Worksheet On Screen

Zooming In And Out On Your Work

Click on the downward arrow next to the Zoom Control Drop Down List

Click on the size you want

Filling The Screen With Your Selected Cells

Select the cells to zoom in on

Click on the downward arrow next to the Zoom Control Drop Down List

Click on Selection

Putting The Display back to Normal

Click on the downward arrow next to the Zoom Control Drop Down List

Click on 100%

Zooming In Our Out To Any Size

Click inside the zoom control box

Type a percentage

Press Return

You Can Also Use The View Menu
View Menu : Zoom will give the same options as above (it’s just another way of doing it)

Working Full Screen

If you want to work full screen, with no icons displayed...
Click on the View Menu

Click on Full Screen A toolbar appears.

To return to normal view, View Menu : Full Screen again

or click on Close Full Screen on the toolbar

Printing

Objectives
By the end of this session you will be able to:-

• 
  Carry out basic printing
  
• 
  Use selective printing
  
• 
  Use print preview
  
• 
  Change the page set-up of your spreadsheet
  
• 
  Change the orientation of the page
  
• 
  Add headers and footers
  

Basic Printing

Basic Printing

To print the worksheet with the print setting as they were set previously:
Click on the Print Icon A dialog box will appear informing you that the spreadsheet is printing

When the box disappears, the entire worksheet will be printed

Printing Only Part Of Your Spreadsheet

Select the area you want to print

Click On File menu The File Menu will drop down

Click on Print


Click on “Selection” in the “Print What” box

Click OK

Other Options In Printing

Click on File Menu

Click on Print

Change the number of copies, the page range and what you want to print

Click OK

Print Preview: So What Will It Look Like On Paper?

Getting A Print Preview

Click on the Print Preview Icon The screen will change to the print preview

Zooming In & Out On The Print Preview Page

Move the mouse over the area to zoom in on

Click
To Zoom out:
Click once more over the page

Adjusting The Margins & Columns In The Print Preview

Click On The Margins Button The Margins and Column Markers will appear

Move the mouse over a margin line or column marker The cursor will change to a cross arrow

Click and drag to adjust the margin or column

Seeing The Next Or Previous Page

Click on the Next button for the next page

Click on the Previous button for the previous page
The bottom left of the screen indicates which page you are on (i.e. Page 1 of 2)

Scrolling Through Lots Of Pages

Use the scroll bar on the right of the screen to scroll though pages quickly.

Changing The Page Setup

Click on the Setup… button The Page Setup box will appear

(See “Page Setup” - page 78) Print and Print preview buttons

Page Setup

Page Setup lets you change many settings regarding how your worksheet will look when printed.

To Access The Page Setup Menu

Click on File The File Menu will drop down

Click on Page Setup The Page Setup box will appear
It can also be accessed from within the Print menu, prior to printing, and from the Print Preview screen.

The Page Setup Tabs

The Page Setup is split into five sections (The chart one is only available when you have a chart selected)
Page Tab Controls page orientation, scaling, paper size, print quality, and starting page number.
Margins Tab Controls the page margins, header and footer margins, and vertical and horizontal centring.
Header/Footer Tab Select a header or footer from the built-in headers and footers. You can also customise a header and footer.
Sheet Tab Controls print area, print titles, page order, black-and-white printing, draft quality, and printing of cell notes, cell gridlines, and row and column headings. The Sheet tab is displayed if the active sheet is a worksheet or macro sheet.
Chart Tab Controls the size, colour, and output quality of printed charts. The Chart tab is displayed if the active sheet is a chart sheet.