Improve this answer. In your Excel workbook click the review After then go to the Changes group and chose the share workbook icon. All Excel options are greyed out - Stack Overflow Select "Unprotect Sheet" from "Protection" section of the drop-down menu to unlock the worksheet. Recently, any Excel file I open has the almost all of the "Home" ribbon greyed out: I can get them to work again by hiding the ribbon and then exposing it again using the arrow to the right of "Share" on the right side of the Title bar. Share. Will grayout Options under Toolbar; many options under Data and >under Window. Board Regular. Click the Ribbon Display Options icon on the top-right corner of the Excel window, to the left of the Minimize icon. The file you have opened is rights-managed using Information Rights Management technology and you do not have permission to forward, copy, modify, print, or fax the file. As a result, commands that would otherwise allow you to perform those functions have been disabled. Joined. Why is a page layout grayed out in Excel? - Quora Jan 29, 2011. In your Excel workbook click the review After then go to the Changes group and chose the share workbook icon. In large spreadsheets. Feb 12, 2011. Insert Rows grayed out - Microsoft Tech Community Why Is My Excel Ribbon Greyed Out - How To Use Excel However, that is exceedingly annoying as this now seems to occur for EVERY spreadsheet I open. Tip. To insert a new row and/or column, select close to the row and/or column and press CTRL + SHIFT = (equal sign) or write click the row or column and select Insert. To Group sheets. Joined. The . Messages. Commands on the Ribbon are disabled because you don't have permission ... Access the Microsoft Excel 2007 Options menu. • Hold down the CTRL key when selecting tabs This answer is cited from Ron Coderre Share Improve this answer For more information, see Information Rights Management in Office. You can see there is an editing tab having the following option " Allow changes by more than one user at the same time…". Go to the Review tab and look in the Protect Sheet icon to see if this is the case. How to show, hide and restore missing ribbon in Excel - Ablebits Alternatively, turning on the Reading Pane in the Outlook Inbox will make the options available. This morning, I must have hit a combination of keys that seems to have resulted in disabling various icons on the menu tabs (For instance, the icons in the Data tab are all greyed out, and in the home tab, the sort and filter and conditional format and format as table icons are greyed out. disabled (greyed out) ribbon icons - Excel Help Forum Micro Excel 2016 Ribbon Options greyed out. File Explorer Ribbons with Home Tabs greyed out - Ten Forums https://www.youtube.com/channel/UCmV5uZQcAXUW7s4j7rM0POg?sub_confirmation=1Some Excel options are Grayed out (inactive) Fix Word Greyed Out Why Is My Microsoft - comuni.fvg.it