|  

» Identifying and selecting the print area in a sheet in Microsoft Excel

Each sheet has only one print area. When you select the print area, Excel creates a name for it - Print_Area. If you do not know what the print area is, select Print_Area from the Name box (to the left of the Formula bar).



Rate This Tip
12 34 5
Rating: 2.01     Views: 37469
financial analyst
Miriam Schober  Posted on: 31-12-1969
There must be a way to print more than one print area per worksheet.

any help is appreciated
Multiple Ranges
Finance & Insurance Manager  Posted on: 31-12-1969
Selecting Multiple Ranges
Even with well-designed worksheets, you may want to select specific ranges that are not contiguous. Instead of printing each range on a separate page, you can print non-contiguous ranges in a cohesive printout.

Select the first range to be printed

Hold down the [Ctrl] key and select the second range to be printed

Repeat step 2 for each additional range to be printed

From the File menu, select Print...
The Print dialog box appears.

Under Print what, select Selection

Click OK
Multiple Print Area
Irawan  Posted on: 31-12-1969
To print multiple print area :
In Page Setup, select Sheet, click Print Area.
Enter or select the first range to be printed and type coma (,) for the second range and so on for the third area.
After selecting or typing all the areas, click OK.
Name
Comment Title
Comments