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.

How do you add a heading to a Numbers spreadsheet

I created a spreadsheet in Numbers. Now I need to add the Title and two subtitles. I typed a title in D1. but the title keeps wrapping around and moving into the spreadsheet I have created. How do I merge cells, center the title and prevent it from wrapping around.?


MacBook Air, macOS 14.5

Posted on Oct 8, 2024 10:01 AM

Reply
3 replies

Oct 8, 2024 1:38 PM in response to Adamfo47

Do you mean column heading/titles? Something like:



This is a multi-step process.


First, make sure the table has two title rows:



In my example, I'm using row 1 as the 'year' and row 2 as the 'who'.


Set the cell B1 to '2023'


Select cells B1:C1


Select Table -> Merge Cells


This will adjust the cell to spread across the selected area.


With the cell still selected, set the alignment to Centered, to center the title across the merged cells:



Did I understand the ask correctly?

How do you add a heading to a Numbers spreadsheet

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