#Excel grayed out options windows#

Show: Formula Bar, Status Bar, Windows in TaskbarĬomments: None, Comment indicator only, Comment & indicator Toolbars or other things controlled in Tools, Options (#missing) Toolbars, Options, View (tab): You are in data entry mode, in the process of changing a cell value or formula - see previous item.

Number, Alignment, Font, Border, Patterns, and Protection tabs. If you can't use the keyboard, and the scroll bars are missing, you are inĪnother worksheet then return to curent worksheet.įormat, cells menu tabs reduced to only the Font tab instead of Submenus, but the submenus are found to be also grayed out. Tools, Share Workbook., remove checkmark from allow multiple users.Īll menu and context menu options are grayed out, except for those with Gray out Conditional Formatting menu option. Shared workbook (Highlight changes is automatic shared workbook) will Probably invalid, like inserting a pagebreak can insert onlyīefore a cell, a column, or a row - not before each cell in column for instance. Tools -> Protection -> Unprotect Workbook Insert menu grayed out, can't insert worksheet. Tools -> Protection -> Unprotect Worksheet Many options under Data and under Window. Will gray out a lot of menu options - notably most Edit options (except cut & paste). Make sure you are not in Edit mode by hitting Esc (Escape key), as edit mode Probably have sheet protection turned on which will turn off several options Right-Click menus are grayed out (Insert., Delete., Format Cells., Pick From List, Hyperlink.) Menus at top grayed out (View, Insert, Format, Tools, Data)., or Look at all of the possibilites even if not listed directly under the Tell you what protection you might have inadvertently turned on. See what options are available under Tools, Protection (#quickcheck)Ī check of Tools, Protection, for Unprotect options can quickly It by running a macro with this line of code: Jim Rech.

If the sum option has been programatically disabled, you can reset Grayed Out Options Grayed Out Options Location: Home page: Īdditional keywords: grayed out, greyed out, unavailable options