thanks, that must be the right way in doing it, but what did I do wrong: I
followed your instructions and then - instead of printing 6 pages - it
printed 22 pages?? and only two of the pages, not all the content - what did
I do wrong?
Sounds like you need to set your print area.
2 ways:
1. file>print area>clear print area. Now select the range you want to print
and go back to file>print area>set print area. (This would be prefered.)
2. View>Page break preview. The dark blue lines can be dragged around by
clicking on them and holding down the right mouse button. They represent the
over all size of your project. The dotted lines represent the individual
pages with in that document. The only advice I will give here is to not
increase the default size excel gives each page by alot because it will
change your printed output. When you get it the way you want to back to
view>Normal. Other wise you will have those page numbers on your viewed
project.
now, this is weird. I did all what you said, (clear print area, select print
area, page break preview etc) but still - it wants to print 22 pages as soon
as I set the "columns to repeat" - when I delete it, it prints 4 pages, only
(how it should be).
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
