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
