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

Range headings 0
Having Blank Cells, etc. ? 1
No row numbering and column lettering 1
Inconsistent formatting of section numbers 0
How to change Colomn headings from (1,2,3,) to (A,B,C,) 3
Weekly Report 2
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Adding sequence numbers to paragraphs 0

Top