|
printing multiple selected rows
how can I print multiple selected rows in a page?!
|
printing multiple selected rows
Hi,
Select the rows you want to print. 1. FILE 2. PRINT 3. under print what --- SELECTION 4. OK "peyman" wrote: how can I print multiple selected rows in a page?! |
printing multiple selected rows
Hi
Not possible manual You can use a macro http://www.rondebruin.nl/print.htm#non-contiguous -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "peyman" wrote in message ... how can I print multiple selected rows in a page?! |
printing multiple selected rows
Hide the ones you don't want to print.
Gord Dibben MS Excel MVP On Fri, 10 Aug 2007 11:44:03 -0700, peyman wrote: how can I print multiple selected rows in a page?! |
printing multiple selected rows
thank you so much Ron.It works!!!
"Ron de Bruin" wrote: Hi Not possible manual You can use a macro http://www.rondebruin.nl/print.htm#non-contiguous -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "peyman" wrote in message ... how can I print multiple selected rows in a page?! |
printing multiple selected rows
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?! |
printing multiple selected rows
thanx Challa I'll try it out
"challa prabhu" wrote: 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?! |
printing multiple selected rows
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!!! "Ron de Bruin" wrote: Hi Not possible manual You can use a macro http://www.rondebruin.nl/print.htm#non-contiguous -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "peyman" wrote in message ... how can I print multiple selected rows in a page?! |
printing multiple selected rows
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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "peyman" wrote in message ... 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!!! "Ron de Bruin" wrote: Hi Not possible manual You can use a macro http://www.rondebruin.nl/print.htm#non-contiguous -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "peyman" wrote in message ... how can I print multiple selected rows in a page?! |
printing multiple selected rows
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!! "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "peyman" wrote in message ... 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!!! "Ron de Bruin" wrote: Hi Not possible manual You can use a macro http://www.rondebruin.nl/print.htm#non-contiguous -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "peyman" wrote in message ... how can I print multiple selected rows in a page?! |
printing multiple selected rows
Hi peyman
There are a lot of things that are not working with shared workbooks Is it working in a normal workbook for you ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "peyman" wrote in message ... 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!! "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "peyman" wrote in message ... 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!!! "Ron de Bruin" wrote: Hi Not possible manual You can use a macro http://www.rondebruin.nl/print.htm#non-contiguous -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "peyman" wrote in message ... how can I print multiple selected rows in a page?! |
printing multiple selected rows
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 "Ron de Bruin" wrote: Hi peyman There are a lot of things that are not working with shared workbooks Is it working in a normal workbook for you ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "peyman" wrote in message ... 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!! "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "peyman" wrote in message ... 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!!! "Ron de Bruin" wrote: Hi Not possible manual You can use a macro http://www.rondebruin.nl/print.htm#non-contiguous -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "peyman" wrote in message ... how can I print multiple selected rows in a page?! |
printing multiple selected rows
Working for me
Send me your test workbook private and I test it for you -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "peyman" wrote in message ... 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 "Ron de Bruin" wrote: Hi peyman There are a lot of things that are not working with shared workbooks Is it working in a normal workbook for you ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "peyman" wrote in message ... 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!! "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "peyman" wrote in message ... 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!!! "Ron de Bruin" wrote: Hi Not possible manual You can use a macro http://www.rondebruin.nl/print.htm#non-contiguous -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "peyman" wrote in message ... how can I print multiple selected rows in a page?! |
printing multiple selected rows
i sent it to your email address.the last column is printed out in the second
page!! thanx "Ron de Bruin" wrote: Working for me Send me your test workbook private and I test it for you -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "peyman" wrote in message ... 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 "Ron de Bruin" wrote: Hi peyman There are a lot of things that are not working with shared workbooks Is it working in a normal workbook for you ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "peyman" wrote in message ... 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!! "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "peyman" wrote in message ... 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!!! "Ron de Bruin" wrote: Hi Not possible manual You can use a macro http://www.rondebruin.nl/print.htm#non-contiguous -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "peyman" wrote in message ... how can I print multiple selected rows in a page?! |
| All times are GMT +1. The time now is 02:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com