Printing the last column on every page printed.
I want to be able to print the last column of my spreadsheet (Total column)
on every page that is printed from this workbook. How can I do this? I'm stumped... Thanks for your help! |
Are all the last columns in the same location (column X for example)?
If yes, you could group all the sheets (click on the first, ctrl-click on subsequent). then select column X File|print|Select (bottom left corner) Do a preview first. But this prints each worksheet (column) on a different sheet. ====== You could have a macro that built a new worksheet and just copy|pastes values| that last column into consecutive columns (A, B, C for each worksheet). Then print that. Heck you could even record a macro when you did it manually and you'd be set. ====== You could create a new worksheet then loop through each "total" worksheet and select the column Edit|copy back to the new worksheet Shift-Edit|paste picture link And butt each picture next to the previous picture. By pasting the picture as a link, these pictures will update when your data/subtotals change. naiveprogrammer wrote: I want to be able to print the last column of my spreadsheet (Total column) on every page that is printed from this workbook. How can I do this? I'm stumped... Thanks for your help! -- Dave Peterson |
All times are GMT +1. The time now is 04:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com