Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
naiveprogrammer
 
Posts: n/a
Default 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!
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Printing and Page Setup Sherry Excel Discussion (Misc queries) 1 January 25th 05 09:38 PM
Printing - Have to set print area 1 column further than necessary STUART BISSET Excel Discussion (Misc queries) 0 January 24th 05 07:59 PM
fitting spreadsheet to page for printing Tim Excel Discussion (Misc queries) 1 January 13th 05 02:54 PM
Printing the page properties as header r_najafi Excel Discussion (Misc queries) 1 January 6th 05 02:59 PM
Excel Web Page Printing ClinicITguy1 Excel Discussion (Misc queries) 0 December 31st 04 05:15 PM


All times are GMT +1. The time now is 08:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"