You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

User profile for user: Sendgridover
Sendgridover Author
User level: Level 1
4 points

Colours icon on toolbar

Using Numbers I have added the Colours icon to the toolbar.


I have noticed however that this function does different things depending on which spreadsheet I have open.

For example: Select a cell, click the Colour icon on the toolbar. In one spreadsheet this function pops up the 'Change Text' colour palette and on another spreadsheet the 'Colour Fill' palette is displayed.


How can I change this so that the Colour Icon only displays the Change Text colour function?

MacBook Air 13″, macOS 15.1

Posted on Nov 8, 2024 1:03 AM

Reply
Question marked as Top-ranking reply
User profile for user: Camelot
Camelot
User level: Level 9
55,305 points

Posted on Nov 8, 2024 10:18 AM

Not something I'd noticed before, but it seems to me that the rule is as follows:


By default, all cells in a table have 'No Fill' as their fill setting (e.g. are transparent).


When you open the color palette, it always defaults to setting the Text Color for the current cell/selection - UNLESS the cell has a fill.


IF the cell has a fill, then the color palette defaults to setting the cell background color, not the text.


Given that, I have to suggest that the 'misbehaving' sheet you describe is working the way it is because the cells on that sheet/table have been filled (even with 'White'?), and therefore Numbers is assuming you want to change the fill color, not the text color.


Simple solution: Select all the cells in the table and set their Fill to 'No Fill'.

View in context
3 replies
Question marked as Top-ranking reply
User profile for user: Camelot
Camelot
User level: Level 9
55,305 points

Nov 8, 2024 10:18 AM in response to Sendgridover

Not something I'd noticed before, but it seems to me that the rule is as follows:


By default, all cells in a table have 'No Fill' as their fill setting (e.g. are transparent).


When you open the color palette, it always defaults to setting the Text Color for the current cell/selection - UNLESS the cell has a fill.


IF the cell has a fill, then the color palette defaults to setting the cell background color, not the text.


Given that, I have to suggest that the 'misbehaving' sheet you describe is working the way it is because the cells on that sheet/table have been filled (even with 'White'?), and therefore Numbers is assuming you want to change the fill color, not the text color.


Simple solution: Select all the cells in the table and set their Fill to 'No Fill'.

Reply

Colours icon on toolbar

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.
Learn more Sign up