The next step is printing! These pages are concerned with the correct ways to print out spreadsheets and a couple of extra little features that you may find useful.
All the changes can be made from the Print Preview screen.
The Print Preview Screen
Print Preview shows you what your sheet will look like when printed but doesn't actually print it. To get access to this screen click on the toolbar icon or go to File then Print Preview.
If you want to view the Preview screen in a larger size, put the cursor anywhere in the worksheet and click once to zoom in. Alternatively, you can click on the button at the top of the Preview screen. Repeat either of these actions to zoom out again.
Page Setup
Click on the Setup button at the top of the Print Preview screen.
You can use Page Setup to do many things - it is worthwhile exploring some of them yourself. For now we shall concentrate on how to print the worksheet on one page.
Select the Page tab
It is always advisable to try and print the finished spreadsheet on one piece of paper. You can achieve this in one of two ways:
NOTE: Neither of these changes is necessary for the present piece of work because it will print comfortably on one page in Portrait orientation.
Printing Gridlines
If Print Preview shows your worksheet without gridlines, change the setting so that the gridlines are printed out. This is how to do it:
- File menu
- Page Setup
- Sheet tab
- Select the Gridlines checkbox so that it shows a tick
- OK
Printing Only a Part of the Spreadsheet
If you only need to print a particular section of your spreadsheet:
- Select the appropriate block of cells
- Go to FILE
- Choose PRINT
Final Printouts
- First print the whole page, making sure that it will fit on one page in PORTRAIT orientation
- Then print out just the section starting at row 25. Again, make sure that this will fit on one page before you send it to the printer.
NEXT: MORE ABOUT CREATING FORMULAS
