(Msg. 2) Posted: Sat May 17, 2008 10:15 pm
Post subject: Re: Printing Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi Michael,
Most likely you are trying to specify both rows and columns as print titles
in a single area. You must set rows for the print titles at the top of each
page and you must specify columns for the print titles you want to see at
the left. In other words you should have something like this in the Rows to
repeat at top box $1:$3 and something like $A:$B in the Columns to repeat at
left. A reference like $A:$B,$1:$2 in either box will generate the above
error.
Cheers,
Shane Devenshire
Microsoft Excel MVP
"Michael Kaendera" <MichaelKaendera.RemoveThis@discussions.microsoft.com> wrote in
message news:0E7863EC-9256-4984-ACA3-8601EA094B73@microsoft.com...
> Using office 2007 Getting the following error
>
> print title must contiguous and complete rows and columns
> --
> Mike2008
(Msg. 3) Posted: Wed Jun 11, 2008 7:59 am
Post subject: Re: Printing Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I am receiving the same error however I have not specified any print titles.
Any ideas?
"Shane Devenshire" wrote:
> Hi Michael,
>
> Most likely you are trying to specify both rows and columns as print titles
> in a single area. You must set rows for the print titles at the top of each
> page and you must specify columns for the print titles you want to see at
> the left. In other words you should have something like this in the Rows to
> repeat at top box $1:$3 and something like $A:$B in the Columns to repeat at
> left. A reference like $A:$B,$1:$2 in either box will generate the above
> error.
>
> Cheers,
> Shane Devenshire
> Microsoft Excel MVP
>
> "Michael Kaendera" <MichaelKaendera RemoveThis @discussions.microsoft.com> wrote in
> message news:0E7863EC-9256-4984-ACA3-8601EA094B73@microsoft.com...
> > Using office 2007 Getting the following error
> >
> > print title must contiguous and complete rows and columns
> > --
> > Mike2008
>
>
(Msg. 4) Posted: Tue Jun 17, 2008 10:55 am
Post subject: Re: Printing Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I was able to get rid of this error by removing my header and footer entries
for the worksheet. I'm not sure what was invalid about them, but once I did
this, I was able to print without getting the above referenced error message.
"Jan" wrote:
> I am receiving the same error however I have not specified any print titles.
> Any ideas?
>
> "Shane Devenshire" wrote:
>
> > Hi Michael,
> >
> > Most likely you are trying to specify both rows and columns as print titles
> > in a single area. You must set rows for the print titles at the top of each
> > page and you must specify columns for the print titles you want to see at
> > the left. In other words you should have something like this in the Rows to
> > repeat at top box $1:$3 and something like $A:$B in the Columns to repeat at
> > left. A reference like $A:$B,$1:$2 in either box will generate the above
> > error.
> >
> > Cheers,
> > Shane Devenshire
> > Microsoft Excel MVP
> >
> > "Michael Kaendera" <MichaelKaendera.TakeThisOut@discussions.microsoft.com> wrote in
> > message news:0E7863EC-9256-4984-ACA3-8601EA094B73@microsoft.com...
> > > Using office 2007 Getting the following error
> > >
> > > print title must contiguous and complete rows and columns
> > > --
> > > Mike2008
> >
> >
(Msg. 5) Posted: Fri Jun 20, 2008 6:33 am
Post subject: Re: Printing Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thanks Bryan unfortunatly I do not have any entries in the header or footer.
Any other ideas?
"Bryan" wrote:
> I was able to get rid of this error by removing my header and footer entries
> for the worksheet. I'm not sure what was invalid about them, but once I did
> this, I was able to print without getting the above referenced error message.
>
> "Jan" wrote:
>
> > I am receiving the same error however I have not specified any print titles.
> > Any ideas?
> >
> > "Shane Devenshire" wrote:
> >
> > > Hi Michael,
> > >
> > > Most likely you are trying to specify both rows and columns as print titles
> > > in a single area. You must set rows for the print titles at the top of each
> > > page and you must specify columns for the print titles you want to see at
> > > the left. In other words you should have something like this in the Rows to
> > > repeat at top box $1:$3 and something like $A:$B in the Columns to repeat at
> > > left. A reference like $A:$B,$1:$2 in either box will generate the above
> > > error.
> > >
> > > Cheers,
> > > Shane Devenshire
> > > Microsoft Excel MVP
> > >
> > > "Michael Kaendera" <MichaelKaendera RemoveThis @discussions.microsoft.com> wrote in
> > > message news:0E7863EC-9256-4984-ACA3-8601EA094B73@microsoft.com...
> > > > Using office 2007 Getting the following error
> > > >
> > > > print title must contiguous and complete rows and columns
> > > > --
> > > > Mike2008
> > >
> > >
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office