Print Rows at Top!!!!!

S

Steve Hubbard

I have a spreadsheet where each print area is five columns wide. There is a
seprate column (with headings) at the left that I want each sheet to print.

I can accomplish this easily. The problem is the top 8 rows also contain
headings (that go across several colums). From File-Page Setup I select
print columns at left and rows at top but it does not work correctly.

Any suggestions.

Steve Hubbard
 
S

Steve Hubbard

Sorry:

It means in the top 8 rows (that I have selected under print rows at top)
there are headings in column A, B, and C. I can only get the headings in
column A to print.

I can not choose to print column A, B, and C (print columns at left) becuase
I do not want the data below row 8 to print.

Thanks

Steve Hubbard
 
M

Myrna Larson

Then you have to change your layout.

Sorry:

It means in the top 8 rows (that I have selected under print rows at top)
there are headings in column A, B, and C. I can only get the headings in
column A to print.

I can not choose to print column A, B, and C (print columns at left) becuase
I do not want the data below row 8 to print.

Thanks

Steve Hubbard
Click to expand...
 

Ask a Question

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.

Ask a Question

Similar Threads

Repeat Row at Top of Worksheet 2
Try agian 1
Printing a Different Row Heading Mid-way through a Spreadsheet 1
Print Column Heads WITHOUT Excel Column Lables 1
Printing non-contiguous rows at the top 1
Print Titles 3
MULTIPLE PRINT AREA 3
How do I repeat rows at the top of SOME of the pages in Excel 2

Top