menu commands are gray

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When making a new file, commands are okay. I have a file I update once per
month, however now some of the menu options are grayed out. Worksheet is not
protected. Can anyone help me?
 
kcohio

You don't say which items are grayed out, so just guessing here.

Possibly you have two or more sheets "grouped" as in selected?

Do you see [Group] behind the filename in title bar?

Note which sheets are grouped. The sheet tabs will be white.

Then right-click on any sheet and "ungroup".

Note: check your data carefully on any sheets that were grouped.

What you have done to one will have been done to others.

Also, if the workbook is protected, some menu items are unavailable.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Many menu options are grayed-out 3
How can I get the commands in excel which are gray, active again? 2
Cut, Copy, Paste, PasteSpecial grayed out. 9
shared workbook - shared workbook options grayed out 0
Options menu grayed out in Excel 2002 1
Save, save as, page setup dimmed out in unprotected excel sheet? 3
'Cannot insert object' message when I try to put a button on a worksheet 7
Cannot insert new worksheet 6

Back
Top