Go to Excel > Preferences in the menu bar and then under the Authoring section click View. But if you’re looking for fewer lines and more wide-open space, you can actually remove the gridlines in Excel for Mac 2011 pretty easily. Grids in Excel are great for lining up rows and columns. You need to shift-click on a single worksheet to deselect the others, and resolve the problem.
The Solution I had inadvertently selected multiple worksheets, *clicking* on a single worksheet doesn’t deselect the multiple worksheet selection – here’s where the bad design causes confusion. I spent half an hour scouring the Internet and reading that it may be to do with my Sharing or Protected Workbook options, but my workbook was neither shared nor protected. I was working in Excel 2010 on a workbook with multiple sheets when I suddenly couldn’t interact with the Insert or Data menus (they were entirely greyed out), I also couldn’t interact with my PivotCharts at all. That’s exactly what I felt like in this situation.
› ▀ ▀ ▀ Why Are Grid Lines Grayed Out Excel 2011 For Mac
