Ruler is still grayed out/not available even though workbook is unlocked

**agentbeauty** · 05-22-2015, 07:00 AM

Hello,

This is my first post and I'm about to start losing my hair over what I would think is a super simple problem.

I use Microsoft 2004 for Mac. I purchased a formatted excel spreadsheet. I was able to unlock it to modify what I needed. However, the ruler is not showing up, so I cannot adjust the size of cells, so the text is overrunning and it looks terrible. It is grayed out and I am unable to select. I added a spreadsheet to the workbook, and the ruler shows up on that.

Why isn't this ruler showing up on the other spreadsheets? Any assistance would be much appreciated.

Screen shot 2015-05-20 at 4.45.02 PM.png
Screen shot 2015-05-22 at 6.52.35 AM.png

**Evolta** · 05-22-2015, 07:40 AM

I am not sure if what I say is correct, but I think it is possible that it's hidden based on macros.
If you can open macro's... try to look for: .DisplayHeadings = False

**agentbeauty** · 05-22-2015, 08:01 AM

Originally Posted by Evolta

I am not sure if what I say is correct, but I think it is possible that it's hidden based on macros.
If you can open macro's... try to look for: .DisplayHeadings = False

Thank you for your response! However, you're going to have to dumb that down a bit for me - I am by no means an excel expert. I'm not sure what macros are or how I'd make that adjustment.