Inspect all the sheets you mean to print to be sure everything is finished. Are all the calculations there? Is the formatting of cells complete?
Are all explanations and comments in place, especially what you meant to have visible on the sheet(s).
Excel may count cells as part of the spreadsheet that you thought you got rid of. This can happen if you have data and format it and then remove the data. The cells may look empty but they can have formatting assigned still. Excel may count them as part of the spreadsheet even though they are empty. Excel 97 is smarter about this that earlier versions, but you still must be careful. Deleting the cells rather than deleting the contents of the cells cures this particular problem.
|Spell Check:||Spreadsheets don't normally benefit as much from Spell Check as your Word documents do. There aren't as many words, for one thing. But it still pays to let Excel check for errors. You don't want to misspell your column and row labels. Quite embarrassing.|
|Page Break Preview:||
View the sheet(s) in Page Break Preview to see if Excel is dividing the way you want. You can drag the blue boundaries to change what is printed on which pages.
If you can't move the page breaks, you have grouped several sheets together. Check the sheet tabs. Right click on one and choose Ungroup if they were grouped
Check the settings on all four tabs for each worksheet to avoid surprises. (
|Print Preview:||Always look at Print Preview before you print. Check the number of pages that will print, in the Status bar. Check for header/footer overlapping the cells. Check that the columns and rows are printing on the pages that you meant for them to print on.|
Pick a printer and the number of copies. Pick what to print - selection, active sheet(s), the whole workbook, or just certain pages. (Be sure you looked at Page Break Preview or Print Preview!)
Teachers: Request permission to use this site with your classCopyright © 1997-2012 Jan Smith <email@example.com>
All Rights Reserved
~~ 1 Cor. 10:31 ...whatever you do, do it all for the glory of God. ~~