MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Do I Spread Text Across Multiple Columns In Numbers?

How do you spread text across multiple columns? I have five columns and I want a universal header centered and spread across all those columns.

In this example, “Samsung TV Auto Equalizer On” does not spread as below but fills a single column.

Channel Duration (seconds LAeq (Average dB) Max Level (dB) Notes
Samsung TV Auto Equalizer On
10 61 43.7 50.9 Samsung TV Auto Equalizer On
14 62 43.4 48.3 On
—–
John Kueck

Comments: One Response to “How Do I Spread Text Across Multiple Columns In Numbers?”

    2 months ago

    Select the cell and go to the Format sidebar, then Text, then uncheck Wrap Text In Cell.

    Now the text should overflow the cell and cover the cells to the right.

    However, if there is a value in the cell to the right, that takes precedence over its own space. So the cell to the right needs to be empty.

Leave a New Comment Related to "How Do I Spread Text Across Multiple Columns In Numbers?"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)