Printing Excel Entire Workbook
 

I have over 100 pages excel file.
I am getting an error message " Print titles must be contiguous and complete
rows or columns" when i am trying to print the entire worksheet.

Printing Excel Entire Workbook
 

look in file/page setup/sheet
it doesn't like the ranges in Print Titles

"leena" wrote:

I have over 100 pages excel file.
I am getting an error message " Print titles must be contiguous and complete
rows or columns" when i am trying to print the entire worksheet.

Printing Excel Entire Workbook
 

I checked in file/page setup/sheet
There is nothing in Print Titles
Please help me.

"dlw" wrote:

look in file/page setup/sheet
it doesn't like the ranges in Print Titles

"leena" wrote:

I have over 100 pages excel file.
I am getting an error message " Print titles must be contiguous and complete
rows or columns" when i am trying to print the entire worksheet.

Printing Excel Entire Workbook
 

leena wrote:
I have over 100 pages excel file.
I am getting an error message " Print titles must be contiguous and complete
rows or columns" when i am trying to print the entire worksheet.
Entire worksheet?
or do you mean "entire workbook" including all sheets?

Bill

Printing Excel Entire Workbook
 

It's easy leena.Right click on sheet name and then choose select all
sheets.and the give print command.

"leena" wrote:

I have over 100 pages excel file.
I am getting an error message " Print titles must be contiguous and complete
rows or columns" when i am trying to print the entire worksheet.

Printing Excel Entire Workbook
 

Did you do this in every worksheet?

"leena" wrote:

I checked in file/page setup/sheet
There is nothing in Print Titles
Please help me.

"dlw" wrote:

look in file/page setup/sheet
it doesn't like the ranges in Print Titles

"leena" wrote:

I have over 100 pages excel file.
I am getting an error message " Print titles must be contiguous and complete
rows or columns" when i am trying to print the entire worksheet.