Excel - Row and column headings missing
Asked By Stev on 09-Aug-07 05:36 PM
I now this is so simple, but I am drawing a blank.
I am working with a worksheet that does not have the row & column headings.
How do I produce them so I can change the column width ?
JE McGimpsey replied on 09-Aug-07 05:41 PM
Tools/Options/View check the "Row & column headers" checkbox.
Trevor Shuttleworth replied on 09-Aug-07 05:44 PM
Tools | Options | Tick "Row and column headers"
Peo Sjoblom replied on 09-Aug-07 05:43 PM
They are under tools>options>view>window options, you can still change the
size by going into format>column/row
Elka replied on 09-Aug-07 05:46 PM
In Excel 2003 or earlier:
From the TOOLS Menu, select "Options"
On the VIEW Tab, check "Row & Column Headers"
In Excel 2007:
Go to the VIEW Tab on the Ribbon
In the "Show/Hide" Section, check "Headings"
PCLIVE replied on 09-Aug-07 05:50 PM
Check 'Row & column headers'
Stev replied on 09-Aug-07 05:52 PM
I said it was simple, but I am even more embarassed now because it is even
simplier than I imagined.