How to Unlock Grayed Out Menus in Excel 2007
- 1). Position your cursor so that it is on one of the sheet tabs at the bottom of the screen. Make sure the sheet tab is highlighted.
- 2). Right-click the sheet tab. Choose "Ungroup Sheets" from the drop-down menu.
- 3). Click one of the menus. All of the options should now be visible. If the options are still grayed out, right-click the sheet tab again and choose "Ungroup Sheets."