ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing Alternate Rows (https://www.excelbanter.com/excel-discussion-misc-queries/99680-printing-alternate-rows.html)

LPS

Printing Alternate Rows
 
Using Excel 2000: You can select alternate rows by using the CTRL button
(e.g.; select rows 2, 4, 6, 8, etc) but when you try to print your selection
(File| Print | Selection) each row prints on a separate page. Is there
something you can tweak to have as many alternate rows as possible print on
the same page?
--
LPS


Jim Cone

Printing Alternate Rows
 
Check out the free Excel add-in "Print Selections Only"
Download from (no registration required) ...
http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
San Francisco, USA


"LPS"
wrote in message
Using Excel 2000: You can select alternate rows by using the CTRL button
(e.g.; select rows 2, 4, 6, 8, etc) but when you try to print your selection
(File| Print | Selection) each row prints on a separate page. Is there
something you can tweak to have as many alternate rows as possible print on
the same page?
--
LPS


LPS

Printing Alternate Rows
 
Thanks Jim. That works nicely.
--
LPS


"Jim Cone" wrote:

Check out the free Excel add-in "Print Selections Only"
Download from (no registration required) ...
http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
San Francisco, USA


"LPS"
wrote in message
Using Excel 2000: You can select alternate rows by using the CTRL button
(e.g.; select rows 2, 4, 6, 8, etc) but when you try to print your selection
(File| Print | Selection) each row prints on a separate page. Is there
something you can tweak to have as many alternate rows as possible print on
the same page?
--
LPS




All times are GMT +1. The time now is 06:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com