print worksheet without ABC and 123 labels showing?

J

JsQuilts

I am trying to print out my worksheet without the column labels (A, B, etc)
and row labels (1,2,etc) showing. I don't want to delete them - they are need
for calculations in the worksheet. I am using Excel from Microsoft Office
Home and Student 2007.
 
B

Bernard Liengme

These are called Row and Column Headings

In XL2007 open the Page Setup tab on Ribbon and look for the Sheet Options
Group (last but one on right). There are checkboxes for both Gridlines and
Headings for both View (worksheet) and Print; Uncheck the box under Heading
next to Print.

In XL2003: File | Page SetUp ; open Sheet tab; uncheck 'Row and Column
headings"
best wishes
 

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
creating labels with excel and mail merge 4
print column labels with one row of data at a time. 8
creating labels using MS exel and MS word mail merge 3
Troubleshoot Custom Labels 4
Exporting Excel into Word to print Labels 1
Worksheet printing 2

Top