Creating multiple paragraphs within a single cell of text in Numbers? Please help.

Hi Stephen,

If you are using Numbers for Mac,

• hold down the option key and press return to insert a paragraph break (hard return) into a table cell;
• hold down the shift and option keys and press return to insert a newline character (soft return) into a table cell.

Text is selected to illustrate.

Regards,

Ian.

Under MacOS typing control-enter or option-enter will give you a line break within a cell.

SG

You need to insert a line break. On iOS this is done by tapping on the text input line, which brings up an “insert” tooltip. Tapping that opens this:

Having no access to the desktop version at the moment I can’t tell you precisely how to add it on that platform, but if you search the in-app help files for “line break” you should get your answer.

Don’t overlook text boxes. They are separate objects, not part of any table, with no cell address and thus cannot be referenced, but they can be moved and resized on the canvas. If you need to write out a large synopsis, it may be worthwhile to create a text box and place it over your table. It will operate as a word processor with limited features, but pressing “enter” will create a line break.

A text box in a Numbers document is like a table in a Pages document. It’s a mini version of one platform inside another, as no one app is ideal for everything.

Hitting “enter” will always move you to the next row, not the next line - you’re using Numbers, after all, not Pages, so if you really want to write out multiple paragraphs of test in Numbers you will have to break that habit.

The line-break should show up in the text as it is being edited as a non-player character. You can navigate around it with the mouse or arrow keys to add text before or after the linebreak. But this is all rather cumbersome. I recommend storing each paragraph in its own cell in a separate “worksheet” table and then concatenating them, with line breaks in between, in the finished version. For example, if your paragraphs are in Sheet 1, Table 1, cells A1-3, you could do this:

Note that the line breaks are strings, and must be enclosed in quotation marks.

Hi Stephen,

You wrote (emphasis added): "I have a large text box where we need to document the events of a day. The issue I'm having is every time I hit enter when I'd like to start a new paragraph it immediately moves to the next cell or creates a new row if I hit it twice.

If this were true, the return key would act as you want it to. The behaviour you describe indicates that what you are calling "a large text box" is actually a cell in the last row of a Table, or a single cell Table. Text boxes are separate from Tables, and are intended to contain 'text' that does not require integration with the calculations occurring in a table.

"Big picture we'd like to create an entire workbook versus separate formats."

Not sure what you are saying here.

My assumption is that by "entire workbook" you mean you want the whole project to be contained in a single Numbers Document, and that "separate formats" means "separate Documents" or files created in different applications.

Using a mixture of Tables and Text boxes within a single Numbers Document could provide a workable solution.

Regards,

Barry

As an aside, it’s easy to see why these reports might not be very popular.... spreadsheets are not word processors, and trying to use them as such, while possible to some degree, is not without its challenges and frustrations. I would try to set up as much of the text as possible in advance as boilerplate, and have the user just enter specific details. There is a lot of possibilities. You could have a pop-up cell where the user specifies what sort of action the report is regarding, and use IF formulas to spit out a list of specific fields for the user to fill out based on their response. Then, using the methods above, a report can be generated that is largely boilerplate or pre-written, while including the specific (one line) details the user has included. Again, using IF logic formulas, the report can adapt automatically based on these details.