Thursday, June 16, 2011

Excel Prints Only A Portion Of Worksheet


Microsoft Excel sometimes prints a portion of worksheet and leaves the rest of the sheet. It is because of there print area that might have been selected or defined but it is given to print whole document.



Resolution: 

1) Check whether a print area is defined. If the worksheet contains a print area, Excel prints only the print area. 

2) To determine whether your worksheet contains a print area, click Page Break Preview on the View menu. 




The area of the worksheet that appears with a white background is the area that is printed. 

1 comments:

Post a Comment

Search This Blog

Followers

Related Posts Plugin for WordPress, Blogger...
Twitter Delicious Facebook Digg Stumbleupon Favorites More