• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

Printing problems are usually related to your printer rather than to the application through which you're printing (Excel, in this case). Some common printing problems and their potential solutions appear in Table 5.4.

Table 5.4. Printing Problems and Solutions
Printing Problem Possible Cause/Solution
One or two columns or rows flow onto a second or other unwanted subsequent page. Too much data to fit on the page. Try reducing margins, or scaling the page to fit on a specific number of pages.
Printing takes too long. A lot of graphic content—fonts, drawings, clip art. Increase the amount of memory in your printer or reduce the amount of graphic content in your worksheet, if possible. If you're on a network, try printing to a printer with more memory. If you have an ordinary laser printer, don't be surprised if it doesn't have enough memory to print even the smallest WordArt graphic.
Portions of your worksheet didn't print. A print area has been defined that doesn't include the parts that are missing from your printout. Reselect the entire desired sections to print, and choose File, Print Area, Set Print Area to reset.
Excel is ignoring the page breaks you set up. Your Page Setup options might be in conflict with one another. Choose File, Page Setup, and on the Page tab, check the Fit To option, and specify the number of pages that your worksheet should print to.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint