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

How do I hide the Column Headings (A,B,C,...) and Row Names (1,2

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

edtam26

For pre xl2007, goto toolsoptionsview tabremove check mark from "Row &
Column Headers"

Mike Rogers

"edtam26" wrote:

How do I hide the Column Headings (A,B,C,...) and Row Names (1,2

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

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.

--
If you like this answer, please click ''Yes.''

Happy calculating!


"edtam26" wrote:

How do I hide the Column Headings (A,B,C,...) and Row Names (1,2

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

Thanks - got it - knew it would be there somewhere.

"Mike Rogers" wrote:

edtam26

For pre xl2007, goto toolsoptionsview tabremove check mark from "Row &
Column Headers"

Mike Rogers

"edtam26" wrote:

How do I hide the Column Headings (A,B,C,...) and Row Names (1,2

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

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"GSnyder" wrote:

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.

--
If you like this answer, please click ''Yes.''

Happy calculating!


"edtam26" wrote:

How do I hide the Column Headings (A,B,C,...) and Row Names (1,2