excel drop down menu does not work

when I clicked drop down menu, such as color, the menu showing choices did not appear like it used to be.

MacBook Air 13", macOS 10.14

Posted on Jul 22, 2019 07:18 AM

Similar questions

Cannot hide columns with merged cells I have 3 columns with 3 merged cells in some rows (including header row). When I select the columns in popup drop menu 'Hide Selected Columns' item is grey and I cannot click on it. When I export into Excel file, and open it in Excel and select the columns in the similar popup drop menu, I see 'Hide' item which is not grey. I click on it and columns disappear. Unfortunately, opening in Numbers the saved Excel file unhides the columns again. It is not convenient to switch to Excel. 😢 Is there some way in Numbers to hide columns with merged cells?
1378 3
After opening a spreadsheet, naming some columns, and putting some numbers in a column, how to I open the menu that gives me choices like sum? How do I get from new spreadsheet to a menu that give the choice to sum
401 2
Numbers - Reset to Default Colour Palette I have a series of matching spreadsheets, but one of them has a muted palette of colours compared to the rest. I'd like it to match the brighter colour palette on the rest of the spreadsheets, which is also the default colour palette I get when I create a new document. I'm not sure why this one spreadsheet has muted colours - I've never intentionally changed to custom colours - but I wonder if it might have been caused by combining it with an Excel spreadsheet at some point in its history - perhaps the colours are default in Excel? Or perhaps it's related to an older version of Numbers and a software update. I think it is an older spreadsheet than the others. Everything appears to match in terms of settings, except for the actual colours. I can see the colours are definitely different because they have different HEX numbers etc when I look in the Colour Fill dialogue. In my spreadsheets, individual cells are coloured in a complex system denoting different stages in tasks, so I can't easily start again in a new document. Also, if I copy and paste the muted spreadsheet content into a new document, I find it also copies the muted colour palette. How do I make the muted colour palette match the brighter default colour palette? Is there a preference somewhere that I can just reset? Images attached below. Any ideas appreciated!
1688 7

3 replies

Old Toad

Level 10

214,314 points

Jul 22, 2019 10:26 AM in response to Bulldog050

Boot into Safe Mode and try from there. Reboot normally and test again.

NOTE: Safe Mode boot can take up to 10 minutes as it's doing some system cache cleaning, volume verifying and directory repairing.

QuickPost

Level 10

103,431 points

Jul 22, 2019 08:31 AM in response to Bulldog050

Hello,

I suggest that you reach out to Microsoft’s support for further assistance.

Jul 22, 2019 08:28 AM in response to Bulldog050

Does that only happen in Excel or also in other Office programs? You could try a reinstall if it keeps failing.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

excel drop down menu does not work