A Printing Question

[kluitna]

I know how to make columns repeat themselves at the left of the page when printing. But is there a way to make a column repeat on the right side of the page also? IE have a totals column repeat on each page along with a title column still repeating on the left. Any help is much appreciated.

[Al Chara]

You can't do it with PageSetup, but maybe one of the gurus knows a way around it.

[kluitna]

Thanks Al,

You would think MS, would have that option, seems pretty obvous to me, maybe it will be a new feature in Excel-XP-V12...

[Chris Davison]

On 2002-03-20 11:29, kluitna wrote:
I know how to make columns repeat themselves at the left of the page when printing. But is there a way to make a column repeat on the right side of the page also? IE have a totals column repeat on each page along with a title column still repeating on the left. Any help is much appreciated.

you did say *any* help :

if you can spare the page width, how about taking a snapshot of the column and pasting it on the right to each page you want printed
?

it's the camera icon, in view / toolbars / customise / commands / tools

[Yogi Anand]

Hi Chris:
Thanks for this tip ... GREAT! I have brought the camera icon on one of the tool bars -- now I have to find ways of using it gainfully. T H A N K S !

[Chris Davison]

*chuckle*

I use it to take snapshots of different parts of the worksheet..... say, summary data ranges where all the column widths are different

you can then just pop the snapshots onto a single sheet and not have to worry about different column widths or anything as they are pictures and will align up perfectly, say if it's an overall summary sheet, maybe in a memo style

(I have to echo Jack here - "Word sucks"... I do all my Word stuff in Excel. In fact, Word really does suck.)

they are also "realtime", in so far as they update themselves when the scource data is updated

Glad it found a use !

[Yogi Anand]

Hi Chris:
Thanks for some more insight into the use of the CAMERA Option. I have another question for you. Do you use the Copy_Picture Paste_Picture in Excel (taking picture this way is static), whereas the CAMERA Picture is dynamic.
Any other comments on comparable features and pros and cons on the use of one versus the other!

[Jack in the UK]

(I have to echo Jack here - "Word sucks"... I do all my Word stuff in Excel. In fact, Word really does suck.)


To add i always end in crossed words over this but excel has weeknesses, like text upside down can not be done, erm no it kinda can a pal Ivan F Moala solved that one!

mail merge,, cant be done .. erm yes its can merge is just batch work all the same... simple vlookup will do. but what of different data say debt owed not so sinmple Ok merge can roll on click the user numbers and bigo debt input

SLOOOOOWWW!

In VBA you can do about 100 to 120 different letter s in a minute well i can and i do all in excel.. no different asnd effort free

I designed the code and evelop it....

what else??? Im stuck!

excel wins

[Yogi Anand]

Thanks Jack for the real world experience information with Excel!

[excelmacro]

Try making a print macro with the following code inserted at the beginning of the macro code

With ActiveSheet.PageSetup
.PrintTitleRows = ""
.PrintTitleColumns = "enter columns to be printed at the edge of each sheet here"
End With