| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet has numeric column headings. Change to alpha headings? | Excel Discussion (Misc queries) | |||
| Change Excel Column Headings from A,B etc to names? | New Users to Excel | |||
| Column headings to numbers and row headings to alphabets? | Excel Discussion (Misc queries) | |||
| How do I create column headings in Excel in the A, B, C etc column | Excel Discussion (Misc queries) | |||
| Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions | |||
Linear Mode
