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.

Classic white background cells in blank format

I want a plain classic background of the cells just like MS-Excel does provide. I tried to find the options but unable to change it. Let me know if anyone knows how to do it.


MacBook Pro 13″, macOS 14.4

Posted on Apr 16, 2024 4:03 AM

Reply
4 replies

Apr 16, 2024 6:28 AM in response to kamrantariq

You mean you don't want the gray background in the headers? This is not Excel so you might not actually want to do that but here are two options:


Be just like Excel and don't use header columns and header rows. Delete them. This might become a problem when you make charts, though. Charts use the headers. You can override the defaults each time but charts will be a lot harder to make.


Or, select the cells and change their background color to white. You can also change all cell borders to 0.35pt if you want it to be completely plain. However, if you make the headers look just like the regular data cells, you may forget that they are special. For one thing, a range address like "B" (instead of B1:B20) to address the entire column does not include header and footer rows.


If you do change the color to white (and the borders all to 0.35pt, if that is your choice), you can add your new style as a table style. If you move that style to be the one at the top left (the first one on the list), it will be the default for new tables. Save your blank document with your new table style as a template so you can use it for future projects.

Classic white background cells in blank format

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