Printing Alternate Rows LPS 17.07.2006 16:49:01 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

Re: Printing Alternate Rows "Ken Wright" <ken.wright[ at ]NOSPAMntlworld.com> 14.08.2006 18:37:52 Add a column, put a formula in such as =MOD(ROW(),2), copy down and then use Data / Filter / Autofilter to filter on the 1 or 0 depending on what you want - then just print as normal. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------­------------------------------­---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------­------------------------------­---------------- "LPS" <LPS[ at ]discussions.microsoft.com> wrote in message news:13683777-4241-4CB9-AA60-ABC792A1EBD0[ at ]microsoft.com... [Quoted Text] > 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