Umbrella column title over two or more columns

I'd like an "umbrella" title over two or more column sub-titles in a numbers document. can this be done?


MacBook Pro (2021)

Posted on Jan 7, 2024 7:10 AM

Reply
Question marked as Top-ranking reply

Posted on Jan 7, 2024 1:21 PM

Pretty easy.


  1. Unselect "Wrap text in cell" in the Format > Text menu.
  2. Make sure that the all the adjacent cells are empty.
  3. Type your long or large text title into the center cell.
  4. Select Align Text to Center in the Format > Text menu.


The text should overhang on both ends (if long enough), and the inside cell borders in the overhung cells will be eliminated.


Jerry

2 replies
Question marked as Top-ranking reply

Jan 7, 2024 1:21 PM in response to CD MAN

Pretty easy.


  1. Unselect "Wrap text in cell" in the Format > Text menu.
  2. Make sure that the all the adjacent cells are empty.
  3. Type your long or large text title into the center cell.
  4. Select Align Text to Center in the Format > Text menu.


The text should overhang on both ends (if long enough), and the inside cell borders in the overhung cells will be eliminated.


Jerry

Jan 7, 2024 8:17 PM in response to CD MAN

Another way is to select cells and merge them via Table > Merge Cells.


But Jerry wisely avoided recommending that as it can sometimes lead to unexplained problems with calculation and sort.


If your table is for display only and you are not doing calculations then Merge Cells might give you a better appearance with less effort. Use that sparingly though, and wherever possible instead just turn off 'Wrap text in cell' and leave the cell to the right blank. In most cases you can get the same appearance.


SG

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.

Umbrella column title over two or more columns

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