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
Question marked as Top-ranking reply

Posted on Apr 16, 2024 6:28 AM

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.

4 replies
Question marked as Top-ranking reply

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.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

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.