Friday, June 10, 2011

Excel Wont Print Multiple Print Areas

If a print area contains nonadjacent areas of a worksheet, Excel prints each area on a separate page by default. However, we can specify that separate parts of a worksheet print on the same page by using one of the following methods.

Print nonadjacent columns side by side :

1) Select the columns you don't want to print, point to Column on the Format menu, and then click Hide.

2) Set one print area that contains all of the columns, including the hidden columns.

Click on Selection and that has all the columns that are selected.


Post a Comment

Search This Blog


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