This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi
There is an Excel chart that was done around the year 2000 and is in great need of updating and I could easily do the update if I had access to the data that produces the chart but the problem is datum are in some cells that I cannot access since all headinhs for rows and columns (I mean letters A, B, C, etc. and numbers 1, 2, 3, etc.) are hidden.
I have searched within the Excel help without luck, so could someone please tell me how to display those headings?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I'm certain I am not editing a cell when the Heading option is greyed out.
It seems more like a security restriction. My question now would be how to get to the security setting that make this happen?
The "Headings" and other options in that section are greyed. Is there a way I can activate them?
That's it! Thanks so much.
Activate the View tab of the ribbon.
In the Show group, tick the check box Headings: