Print Column Heads WITHOUT Excel Column Lables

S

Sarah E

I'm trying to print the column heads, and I have gone into file> page setup>
sheet> and tried both "rows to repeat at top" and highlighted the rows I
wanted, and also clicked "row and column headings." When I go to print,
though, my row is on every page, but it is not at the top, the Excel labels
(A,B,C,D) are at the top, and the Excel numbers (1, 2, 3, 4) are on the side
of every page!! I have even added a row and column, but they still show up
on every page! It looks incredibly unprofessional. Anyone know how to fix
this?
 
G

Gord Dibben

By selecting "row and column headers" you ensured they will print.

Uncheck that option.

Leave the "rows to repeat at top" as $1:$1


Gord Dibben MS Excel MVP
 

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

Printing a Different Row Heading Mid-way through a Spreadsheet 1
Alpha column lables 2
Page Break Column Headers 1
Try agian 1
Unhide column difficulty 3
using the =page! feature to transpose a row to column 0
Print Titles 3
Excel MSO 2010 - Excel 3

Top