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

M

Mike Rogers

edtam26

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

Mike Rogers
 
G

GSnyder

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.
 
S

Shane Devenshire

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
How do I display an excel wrksht without column headings (A,B,C)? 2
Column headings 2
Messed up Zoom 6
How: reset the column headings from numeric to alphabetic? 1
Row heading height 1
Changing Column Titles in Excel 2

Top