Hi
I am trying to apply a custom format in my spreadsheet but the function is greyed out. This is happening on every tab and table.
I copied a cell from another spreadsheet with a custom format and i now have a specific custom format but still the create function is unavailable.
I have opened a new spreadsheet and the function is available.
Is there a setting that needs to be turned on?
Many thanks for your help in advance.
Alan
MacBook Pro 13", 10.14
Hi
Solution. Turned off collaboration and it worked.
Hi
Solution. Turned off collaboration and it worked.
Hi Alan,
A couple of questions.
What version of Numbers? Numbers Menu > About Numbers.
What version of the operating system? Apple Menu > About This Mac.
Your answers will help us to help you.
Regards,
Ian.
After selecting a cell or cells and going here you're seeing 'Create Custom Format...' greyed out?
If so, I can't reproduce the problem here. You might try quitting Numbers, restarting your Mac and trying again, perhaps with a new document.
SG
Not sure. It could be the collaboration, which I haven't used much. You might try reporting to Apple via Numbers > Provide Numbers Feedback in your menu.
SG
Hi SG
Thanks for you help. This is what i have done:
Completely shut down and restarted.
opened the offending spreadsheet (SS1) - create custom format is greyed out
opened a new spreadsheet (SS2) - create custom format is selectable
copied tables from SS1 to SS2 but it did not copy the formulas - create custom format is selectable
so it looks like SS1 is corrupt in some way or is it because i am collaborating SS1 with another person?
Thanks
Alan
Hi Ian
Version of numbers = version 5.3 (5989)
Version OS = MOJAVA version 10.14.2 (18C54)
Regards
Numbers: Create Custom Format is greyed out
