Printing column area

[Guest]

I would like to print a column area in repeated pages (not the whole column). Any ideas?

 

[Jim Rech]

It's not totally clear to me what you're asking. But if it is, how do you
limit the print area to a specific range, first select the range and then
use File, Print Area, Set Print Area.

 

[Guest]

Well that is how to print a certain range but what I am asking is that I want a certain part of the column to be repeated in all the pages. By clicking Page Setup/Sheet and ticking the option "columns to repeat at left" it takes the whole column and not a part of it. I just want a part of the column to be repeated (not the whole column). Thanks.

----- Jim Rech έγÏαψε: ----

It's not totally clear to me what you're asking. But if it is, how do yo
limit the print area to a specific range, first select the range and the
use File, Print Area, Set Print Area

 

[Jim Rech]

I just want a part of the column to be repeated (not the whole column).

Got you. Well, the part of the column that is printed to the left is the
same rows that are in the print area. So if the print area is F10:J20, the
rows of, say, column A that are printed are 10:20. Sorry but I don't think
you can anything abou that.

So, not to print certain cells in the left column would require some other
workaround. Like changing their number format to ;;; to make them
invisible. A macro could make that easy to do...