Hi,

The following section describes other alternative -Creating View, Printing
Custom View and Deleting Custom view.

A. Create a custom view

1. Change the settings that you want to save in the view.
2. On the View menu, click Custom Views.
3. Select multiple rows, or selective rows by pressing the Ctrl Key.
3. Click Add.
4. In the Name box, type a name for the view.

Make sure to include the active sheet name in the name of a view to make it
easier to identify. When you display a view, Microsoft Excel switches to the
sheet that was active when you created the view. Excel lists all views in the
workbook in the Custom Views dialog box.

5. Under Include in view, select the options you want.
Note You cannot create a custom view when a worksheet contains an Excel
list. If one or more worksheets contain an Excel list, the Custom Views
command is disabled for the entire workbook.

B. Print a custom view

1. On the View menu, click Custom Views.
2. In the Views box, click the name of the view you want to print.
3. Click Show.
4. Click Print . Under the Print what section, in the Print dialog box,
click Selection.
5. Click OK.

Note:

Microsoft Excel saves previously defined print areas (print area: One or
more ranges of cells that you designate to print when you don't want to print
the entire worksheet. If a worksheet includes a print area, only the print
area is printed.) for each sheet in the workbook with your view. If a sheet
has no defined print areas, Microsoft Excel prints the entire worksheet.

C. Delete a custom view

1. On the View menu, click Custom Views.
2. In the Views box, click the name of the view you want, and then click
Delete.


Challa Prabhu

"peyman" wrote:

how can I print multiple selected rows in a page?!