Apple Event: May 7th at 7 am PT

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Bulldog050 Author

Level 1

4 points

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 7: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?
711 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
91 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!
479 7

3 replies

Old Toad

Level 10

207,679 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,305 points

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

Hello,

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

Jul 22, 2019 8: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.

excel drop down menu does not work