Hide row and column labels

  • Thread starter Thread starter Pam
  • Start date Start date
P

Pam

How can I hide the row and column headings in a
spreadsheet. (the a, b, c, etc. across and the 1, 2, 3,
etc. down)
Thanks!
 
Hi Pam!

Use:

Tools > Options > View
Remove check from "Row and Column Headers"
OK
 
Record a macro while you are doing it

ActiveWindow.DisplayHeadings = False

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
You must log in or register to reply here.

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

Having Blank Cells, etc. ? 1
Excel - Hiding Column Headings (A,B,C,...) and Row Names (1,2,3,.. 4
Countif cells two rows in corresponding columns 9
Excel EXCEL - using a date dependant formula to hide rows 3
How to sort entire spreadsheet by one column sort 5
Column headings - urgent help needed please 3
Excel Help to copy information from one row at a time to another sheet 1
Hiding Header Columns abc... in 2007 1

Back
Top