using office 2000, i want to print selections of a spreadsheet; i want to print A1 to L1 (column headings) with A12 to L12 down to and including A60 to L60 any ideas would be appreciated as accountant is chewing my ears to get my accounts in.
If you go to print setup from the file option and click on sheet, it gives you the option of rows to repeat at the top - use this to select your header row. Once you have done this I think you should be able to select the area of data and go to Print and then print selection. Do a quick preview and you will see you get the header row on the top of your data.
1. Select rows 2 to 11; 2. Click Format; 3. Click Row; slide along to "hide" and click it; [This hides all the rows you don't want] 4. Select cells A1 to A60; 5. Type ctrl+P; 6. Choose "Selection" and click OK.
I'd already tried VoG's suggestion but it gave me a big gap where the unwanted rows should have been and the above doesn't. It could be my printer (Jaws PDF - saving paper)I suppose.
This thread is now locked and can not be replied to.