print freezed pane
 

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).

why is this?



"Mike Rogers" wrote:

panambi

Sounds like you need to set your print area.
2 ways:
1. fileprint areaclear print area. Now select the range you want to print
and go back to fileprint areaset print area. (This would be prefered.)
2. ViewPage 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
viewNormal. Other wise you will have those page numbers on your viewed
project.

I hope this helps

Mike Rogers

"panambi" wrote:

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?

"Mike Rogers" wrote:

panambi

FilePage setupSheet TabColumns to repeat at left.

Mike Rogers

"panambi" wrote:

one more question: how do I do the set up, if I want to have the freezed
column printed on each page?

print freezed pane
 

hi,
what do you see in page break preview? does the print area(white) go beyond
the blue dotted lines? also what is it printing on the extra pages?

Regards
FSt1

"panambi" wrote:

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).

why is this?



"Mike Rogers" wrote:

panambi

Sounds like you need to set your print area.
2 ways:
1. fileprint areaclear print area. Now select the range you want to print
and go back to fileprint areaset print area. (This would be prefered.)
2. ViewPage 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
viewNormal. Other wise you will have those page numbers on your viewed
project.

I hope this helps

Mike Rogers

"panambi" wrote:

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?

"Mike Rogers" wrote:

panambi

FilePage setupSheet TabColumns to repeat at left.

Mike Rogers

"panambi" wrote:

one more question: how do I do the set up, if I want to have the freezed
column printed on each page?

print freezed pane
 

hi!

no, the print area does not go beyond the dotted lines.

the print preview shows 22 pages with only two pages (repeated) from a
4-page document.

i don't understand this, this is so weird...

"FSt1" wrote:

hi,
what do you see in page break preview? does the print area(white) go beyond
the blue dotted lines? also what is it printing on the extra pages?

Regards
FSt1

"panambi" wrote:

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).

why is this?



"Mike Rogers" wrote:

panambi

Sounds like you need to set your print area.
2 ways:
1. fileprint areaclear print area. Now select the range you want to print
and go back to fileprint areaset print area. (This would be prefered.)
2. ViewPage 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
viewNormal. Other wise you will have those page numbers on your viewed
project.

I hope this helps

Mike Rogers

"panambi" wrote:

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?

"Mike Rogers" wrote:

panambi

FilePage setupSheet TabColumns to repeat at left.

Mike Rogers

"panambi" wrote:

one more question: how do I do the set up, if I want to have the freezed
column printed on each page?

print freezed pane
 

and, if i delete the column to repeat it prints the 4 pages - but without the
repeated column...

"FSt1" wrote:

hi,
what do you see in page break preview? does the print area(white) go beyond
the blue dotted lines? also what is it printing on the extra pages?

Regards
FSt1

"panambi" wrote:

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).

why is this?



"Mike Rogers" wrote:

panambi

Sounds like you need to set your print area.
2 ways:
1. fileprint areaclear print area. Now select the range you want to print
and go back to fileprint areaset print area. (This would be prefered.)
2. ViewPage 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
viewNormal. Other wise you will have those page numbers on your viewed
project.

I hope this helps

Mike Rogers

"panambi" wrote:

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?

"Mike Rogers" wrote:

panambi

FilePage setupSheet TabColumns to repeat at left.

Mike Rogers

"panambi" wrote:

one more question: how do I do the set up, if I want to have the freezed
column printed on each page?

print freezed pane
 

do you by chance have hidden columns adjacent ot the frozen column?

"panambi" wrote:

and, if i delete the column to repeat it prints the 4 pages - but without the
repeated column...

"FSt1" wrote:

hi,
what do you see in page break preview? does the print area(white) go beyond
the blue dotted lines? also what is it printing on the extra pages?

Regards
FSt1

"panambi" wrote:

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).

why is this?



"Mike Rogers" wrote:

panambi

Sounds like you need to set your print area.
2 ways:
1. fileprint areaclear print area. Now select the range you want to print
and go back to fileprint areaset print area. (This would be prefered.)
2. ViewPage 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
viewNormal. Other wise you will have those page numbers on your viewed
project.

I hope this helps

Mike Rogers

"panambi" wrote:

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?

"Mike Rogers" wrote:

panambi

FilePage setupSheet TabColumns to repeat at left.

Mike Rogers

"panambi" wrote:

one more question: how do I do the set up, if I want to have the freezed
column printed on each page?

print freezed pane
 

no, no hidden columns...

"dave roth" wrote:

do you by chance have hidden columns adjacent ot the frozen column?

"panambi" wrote:

and, if i delete the column to repeat it prints the 4 pages - but without the
repeated column...

"FSt1" wrote:

hi,
what do you see in page break preview? does the print area(white) go beyond
the blue dotted lines? also what is it printing on the extra pages?

Regards
FSt1

"panambi" wrote:

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).

why is this?



"Mike Rogers" wrote:

panambi

Sounds like you need to set your print area.
2 ways:
1. fileprint areaclear print area. Now select the range you want to print
and go back to fileprint areaset print area. (This would be prefered.)
2. ViewPage 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
viewNormal. Other wise you will have those page numbers on your viewed
project.

I hope this helps

Mike Rogers

"panambi" wrote:

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?

"Mike Rogers" wrote:

panambi

FilePage setupSheet TabColumns to repeat at left.

Mike Rogers

"panambi" wrote:

one more question: how do I do the set up, if I want to have the freezed
column printed on each page?

print freezed pane
 

and when I try to markt the column to repeat, I can't mark that single
column, but the whole first column and the whole first row is marked with
dotted lines....

"dave roth" wrote:

do you by chance have hidden columns adjacent ot the frozen column?

"panambi" wrote:

and, if i delete the column to repeat it prints the 4 pages - but without the
repeated column...

"FSt1" wrote:

hi,
what do you see in page break preview? does the print area(white) go beyond
the blue dotted lines? also what is it printing on the extra pages?

Regards
FSt1

"panambi" wrote:

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).

why is this?



"Mike Rogers" wrote:

panambi

Sounds like you need to set your print area.
2 ways:
1. fileprint areaclear print area. Now select the range you want to print
and go back to fileprint areaset print area. (This would be prefered.)
2. ViewPage 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
viewNormal. Other wise you will have those page numbers on your viewed
project.

I hope this helps

Mike Rogers

"panambi" wrote:

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?

"Mike Rogers" wrote:

panambi

FilePage setupSheet TabColumns to repeat at left.

Mike Rogers

"panambi" wrote:

one more question: how do I do the set up, if I want to have the freezed
column printed on each page?

print freezed pane
 

hi again,
i've been doing some testing and can't seem to duplicate your problem.
why are you doing columns to repeat instead of rows to repeat. i am sure
that the setup of this is the problem but i can't see your file.

regards
FSt1

"panambi" wrote:

and, if i delete the column to repeat it prints the 4 pages - but without the
repeated column...

"FSt1" wrote:

hi,
what do you see in page break preview? does the print area(white) go beyond
the blue dotted lines? also what is it printing on the extra pages?

Regards
FSt1

"panambi" wrote:

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).

why is this?



"Mike Rogers" wrote:

panambi

Sounds like you need to set your print area.
2 ways:
1. fileprint areaclear print area. Now select the range you want to print
and go back to fileprint areaset print area. (This would be prefered.)
2. ViewPage 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
viewNormal. Other wise you will have those page numbers on your viewed
project.

I hope this helps

Mike Rogers

"panambi" wrote:

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?

"Mike Rogers" wrote:

panambi

FilePage setupSheet TabColumns to repeat at left.

Mike Rogers

"panambi" wrote:

one more question: how do I do the set up, if I want to have the freezed
column printed on each page?