OmniDocHow to wrap lines in online tables: How to wrap lines in cells
In the online form, pressing Enter will jump to the next cell. To wrap lines in a cell, use shortcut keys or automatic line wrapping. This article explains the two methods, commonly used shortcut keys, checks after line breaks, and common problems.
Key points of this article
- To branch rows in the same cell, use the manual line wrap shortcut key; to have the text automatically wrap according to the column width, use the automatic line wrap setting.
-Alt+Enter is commonly used in Windows and Control+Option+Enter is commonly used in macOS. The details will depend on the software used.
- Line breaks will be saved with the content, which may cause problems when used for calculation or importing data. Please check in advance.
- Adjust the row height and column width after wrapping, otherwise the text may be truncated and look like there is no wrapping.
When entering addresses, notes or multi-line descriptions in a form, many people will encounter the same problem: the text keeps extending to the right, or pressing Enter jumps directly to the next box. So I thought the table did not support line breaks within cells. In fact, as long as you master a shortcut key or turn on automatic word wrapping, you can branch lines in the same grid. The key to how to wrap rows in an online table is to first think clearly whether you want to "break somewhere" or "wrap rows along the column width".
This article is written for people who make registration forms, checklists, and schedules on the web or desktop. This article talks about two ways of wrapping, common shortcut keys, checking methods after wrapping, and possible mistakes. If you are using the UniCell table in the OmniDoc desktop client, the basic editing of cells is the same as that of a normal table, and the following method also applies.
How to wrap the online form? One sentence conclusion
If you just want to break the line at a certain position, use the manual line wrap shortcut key; if you want the text to automatically wrap with the width of the column, turn on the automatic line wrap of the cell. Both can be used alone or at the same time.
| your situation | Recommended practices | reason |
|---|---|---|
| I just want to break the line somewhere, for example, the address is divided into two lines. | Manual line wrapping shortcut key | The breakpoint is decided by you and the location is fixed. |
| For long remarks, I hope the lines will be folded according to the width of the column. | Enable automatic line wrapping | Text will automatically reflow when column width is adjusted |
| Multiple lines pasted from other documents | After pasting, check each frame and adjust manually if necessary. | Pasting may lose or alter original line breaks |
| The form needs to be exported for others to print. | Set the column width first, then set automatic line wrapping | Avoid uneven row heights after exporting |
| Number grid or formula grid | Try not to break lines inside | After line wrapping, the content may become text, affecting calculations. |
# before you start: confirm these points first
Judge a few things before you start, so you can do less rework.
- confirm the form type. shortcuts may vary from software to software. First confirm which table tool you are using, and then check the corresponding shortcut keys. - confirm the use after the line break. the newline character is saved with the content. If the table is to be imported into the database or read programmatically, the newline character may be used as a delimiter, causing a row of data to be split into two rows. - confirm column width. enable automatic line wrapping when the column is too narrow, the row height of a cell will be propped up very high, and the whole table will appear very messy. First adjust the column width to the appropriate width. - confirm that the cells are not merged. the line height adjustment is sometimes abnormal when merging line breaks in cells. If this happens, cancel the merge first, and then change the line. - confirm the final viewing method. the display on the screen may be different from that after exporting to PDF or Word. It is recommended to check it with the format you actually want to deliver.
# steps to manually wrap lines in a UniCell table
Let's change the behavior example manually. The setting of automatic line wrapping is described in the following steps.
- Double-click the target cell, or select the cell and start typing directly to allow it to enter the editing state.
two. Enter the first line of text and stop the cursor where you want to disconnect.
- Press the shortcut key to wrap. In most table software, Windows is commonly used in Alt+Enter,macOS and Control+Option+Enter is commonly used. If the keystroke does not respond, check the shortcut key description of the software you are using.
- Continue to enter the second line. If you need to split another line, repeat step 3.
- When the input is complete, press Enter or click another cell to confirm the edit.
- If the cell is not displayed as multiple lines, select the cell to turn on automatic line wrapping in the cell formatting.
- Drag the column width or row height so that the text of all rows is fully displayed.
- Check the display effect. If you need to modify it, double-click the cell again and add or delete new lines at the corresponding location.
# check item by item after completion
After the line wrapping is completed, it is recommended to check it item by item, especially if the form is to participate in the calculation or export.
| Check item | What do you think? | What if there's a problem? |
|---|---|---|
| Line break position | Double-click the cell to see where the cursor stops | Re-edit to delete extra newline characters |
| Is the text truncated? | See if any text is covered at the bottom of the cell | Drag row height, or widen column |
| Formula result | Check whether the formula referencing the cell is normal | Change the newline back to a single line, or calculate it after it is processed by a text function. |
| Paste content | Compare paragraph by paragraph with the original text | Clean up extra line breaks and spaces one by one |
| Export effect | Preview after export | Re-export after adjusting column width |
| Data import | Check whether the number of record rows is correct in the target system | Replace line breaks with other delimiters before importing |
# Common line wrapping problems and solutions
In some cases, it looks like a line break failure, but it is actually a matter of setup or the content itself. When encountered, you can check according to the following ideas: first confirm whether the shortcut keys are occupied by the input method or system, then confirm whether the cell is turned on automatic line wrapping, and finally check the row height and column width. If the table content is long, also pay attention to whether the merged cells affect the display.
In addition, if your form contains a large amount of data, it is recommended to back up an original file before changing the line. In this way, even if the modified effect is not ideal, it can be recovered quickly.
# frequently asked questions (FAQ)
1. Why can't you see the change after the online table is wrapped?
There are usually two reasons: the shortcut key does not really work, or the cell does not turn on automatic line wrapping. First double-click the cell to confirm the cursor position, then check the automatic line wrapping option in the formatting, and finally adjust the line height.
2. How do I delete a line break in a cell?
Double-click to enter the editing state, place the cursor on the newline, and press Delete or Backspace to delete the newline character. If there are many places to delete, it is recommended to deal with them one by one, or use the find and replace function to process them in batches.
3. Can I change the number grid?
Technically yes, but it is not recommended. The content may be recognized as text after line wrapping, and it is easy to make mistakes when summing and sorting. Try to keep a single line in the numeric grid, and consider wrapping the words in the remarks class.
4. Will the sorting be messy after the line break?
Sorting is done by the contents of the cell, and newline characters are retained in the content. If the sort results are not as expected, check to see if the column contains hidden line breaks or extra spaces.
5. How do I change the form application on my mobile phone?
Different mobile form applications have different ways to wrap lines, some through specific keys on the keyboard, some need to press long or enter the editing menu. Please see the help instructions for the application you are using.
# Summary
How to wrap an online table, the core only needs two steps: to break somewhere, use the line break shortcut to manually break the line; to fold the line with the column width, turn on the automatic line break. After wrapping, check the row height, formula, export effect, and import results, and the table will be both good-looking and easy to use.
