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

Print (physical or pdf) not respecting format of source document 0
Format column widths from one table to a separate table on same page 1
Mail Merge Help 1
Indenting every other paragraph in Word at the same time? 0
Space at end of multi page list to accommodate new entries 1
Integrating information from Word to Excel (not mail merge) 1
Need Help with a VBA subroutine 0
Two columns followed by single page-width column on same page 0

Top