Spreadsheets Task 8

• Change worksheet margins: top, bottom, left, right
• Change worksheet orientation: portrait, landscape. Change paper size Adjust page setup to fit worksheet contents on a specified number of pages Add, edit, delete text headers, footers in a worksheet
• Insert and delete fields: Page numbering information, date, time, file name, worksheet name into headers, footers
• Turn on, off display gridlines, display of row and column headings for printing purposes Apply automatic title row(s) printing on every page of a printed worksheet
• Print a selected cell range from a worksheet, an entire worksheet.

Task Instructions

Open Task 7 that you created in the previous lesson, we are going to use it to find out how to prepare it for printing.

1. Setting a print area: The first thing that we want to do before we print is to make sure that we are only going to print the area we want and not everything that may be on the worksheet. Select your table only and set the print area.
2. Inserting a header and footer: To make sure we know the work is yours you are going to insert a header or footer. Each page should have your name as well as the date and page number.
3. Page orientation: Change the orientation of your page to landscape.
4. Row, column headings & gridlines: Make sure that Row, Column headings and Gridlines are visible in print preview.
5. Fit to one page: It is quite likely that your table does not fit on one page, if this is the case change the page set up, you could possibly adjust the margins, etc, and adjust the size until all of your work fits on one page. Ask your teacher to show you the ‘fit to one page’ option.
6. When your teacher has checked your spreadsheet you can print it off.
7. Show formulas: In order to see the formulas and functions you have used we will also need to see the work in formula editing mode. Turn on formula editing, and make sure that the sheet in this view still fits on one page.
8. Print options: When it has been checked by your teacher you can print it off.