G
Guest
how can I print multiple selected rows in a page?!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Hi,
Select the rows you want to print.
1. FILE
2. PRINT
3. under print what ---> SELECTION
4. OK
Select the rows you want to print.
1. FILE
2. PRINT
3. under print what ---> SELECTION
4. OK
R
Ron de Bruin
G
Gord Dibben
Hide the ones you don't want to print.
Gord Dibben MS Excel MVP
Gord Dibben MS Excel MVP
G
Guest
thank you so much Ron.It works!!!
Ron de Bruin said:
G
Guest
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
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
G
Guest
thanx Challa I'll try it out
challa prabhu said: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
G
Guest
hi Ron,
when I use the macro, the print is made in two pages!! how can I set up the
print for one page.the columns A to H are in one page, I,J,... in the next
pages!!!
when I use the macro, the print is made in two pages!! how can I set up the
print for one page.the columns A to H are in one page, I,J,... in the next
pages!!!
R
Ron de Bruin
Hi peyman
You can add this to the code beofre the print line
With ActiveSheet.PageSetup
.Zoom = False
.FitToPagesWide = 1
.FitToPagesTall = False
.Orientation = xlLandscape
End With
You can add this to the code beofre the print line
With ActiveSheet.PageSetup
.Zoom = False
.FitToPagesWide = 1
.FitToPagesTall = False
.Orientation = xlLandscape
End With
G
Guest
hi Ron,
I tried it one time before line "newsh.PrintOut" and one time before
"newsh.Columns.AutoFit".but it didn't work! I still have the problem.By the
way, this module creates new worksheets in share workbooks!!
I tried it one time before line "newsh.PrintOut" and one time before
"newsh.Columns.AutoFit".but it didn't work! I still have the problem.By the
way, this module creates new worksheets in share workbooks!!
R
Ron de Bruin
Hi peyman
There are a lot of things that are not working with shared workbooks
Is it working in a normal workbook for you ?
There are a lot of things that are not working with shared workbooks
Is it working in a normal workbook for you ?
G
Guest
hi Ron,
It's not working.It's still printing in 2 pages! I've already added the
additional code but it didn't work.
thanks for your help
It's not working.It's still printing in 2 pages! I've already added the
additional code but it didn't work.
thanks for your help
R
Ron de Bruin
Working for me
Send me your test workbook private and I test it for you
Send me your test workbook private and I test it for you
G
Guest
i sent it to your email address.the last column is printed out in the second
page!!
thanx
page!!
thanx