Excel - Hiding Column Headings (A,B,C,...) and Row Names (1,2,3,..

  • Thread starter Thread starter edtam26
  • Start date Start date
edtam26

For pre xl2007, goto tools>options>view tab>remove check mark from "Row &
Column Headers"

Mike Rogers
 
If you're using Excel 2003, it's under Tools -> Options. I think it's under
Display Options there. Poke around in there, I'm pretty sure it's in View or
Display options.

In 2007, it's under the Office Button in Excel Options. There, under the
Advanced tab, you'll find "Display options for this worksheet". It's the
first option there.
 
Hi GS,

2003: Its Tools, Options, View and uncheck Row & Column Headers.

2007: As you say. Or press Alt+1 to open the Excel Options dialog.
 

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
How to change Colomn headings from (1,2,3,) to (A,B,C,) 3
Column headings 2
How do I display an excel wrksht without column headings (A,B,C)? 2
Change the properties of the worksheet row or column header bars 6
COLUMN HEADING CHANGED FROM ALPHABET TO NUMERIC 1
Messed up Zoom 6
In Excel, how do I rename the gray rows/columns (1,2,3/A,B,C)? 1

Back
Top