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.

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

Alternating color rows - not working for first column

Why does the alternating colour row feature work for the whole spreadsheet EXCEPT the first column?? The entire first column, all the way down, remains white. Why is this? Is there a straightforward way to do this, or a workaround, or can it simply not be done in Mac Numbers?


I'm using the desktop version of Numbers 11.1.

Posted on Nov 11, 2021 6:59 AM

Reply
Question marked as Top-ranking reply

Posted on Nov 11, 2021 9:19 AM

I suspect column A has been defined as a Header Column, and that Alternating Row Color applies only to the Body cells in alternating body rows. Header Columns (and Header rows) have their own colour fill, which overrides the Alternate Color fill.


Regards,

Barry

Similar questions

6 replies

Nov 11, 2021 1:31 PM in response to Badunit

Thanks for joining and chiming in, Badunit.

Good extension, and one I'd neglected. Here's an extension that avoids much of the drudgery from doing it with a long table:


  • Start with the original state of the table—assigned colour fill in the header row(s) and column(s), no fill in the body rows:
  • Select all the non-header rows of the table. (You can include header column cells in this selection, but they won't be changed by the first steps.)
  • Click Format to open the Format Inspector, and click the Alternating Row Color box to check it. Click the beachball by the color well beside it to choose the colour you want to fill the alternate rows.


  • Select rows 2 to 5 of column A
    • (Ignore the row numbers shown in the illustrations—I constructed the example on a table with several rows hidden.)
  • Set all four cells to Color Fill, and set the colour to match the coloured alternate rows.
  • Then deselect the cells on the rows that should be coloured, and set the colour fill on the still selected cells to No Fill.
  • Reselect the four cells, then, press option-command-c to copy the style of these four cells.

    • With Cells A2 to A5 still selected, scroll to the bottom of the table and shift-click on the last cell in the column to add it and all cells between it and A5 to the selection.
    • With all cells from A2 to the last cell in column A now selected, press option-command-V to paste the alternating styles into all selected cells.



Takes some time to describe, but much less tim to do!


Regards,

Barry

Alternating color rows - not working for first column

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