Uživatelská příručka k Uletu

Začněte používat Ulet pro {platform}.

Wrap Text in Spreadsheet Cells on Windows

Wrapped text displays a longer label on more than one line inside its cell. It is useful when a description needs more room but a wider column would make the whole table awkward to read.

For matching example data, use the Practice workbook section at the end of this guide.

Wrap a description

  1. Open a working copy of the expense workbook.

  2. On Expenses, enter Adjustable desk lamp for the shared review workspace in A4.

  3. Commit the text and select A4 again.

  4. On Home, choose Wrap text for the selected cell.

  5. If the last line is clipped, drag the lower boundary of row header 4 downward until the complete description is visible.

English expense worksheet with a longer desk lamp description wrapped onto multiple lines in A4

View screenshot at full size

The description stays in one cell while its visible text uses several lines.

Review the row

The amount 45 and the other fields on row 4 should still belong to the desk lamp entry. Wrapping is a cell appearance change; it does not split the item into additional data rows.

Use enough row height for the text and avoid making neighboring numeric values hard to scan. Check the result at a comfortable zoom level.

Keep the display

Press Ctrl+S and reopen the workbook. Confirm the complete description, its wrap setting, and the position of the associated amount.

Practice workbook

To reproduce this example, start with a separate practice copy. On Ulet Home, choose Sheets. Rename the first worksheet Expenses and enter the following values in A1:E6. Enter amounts as numbers.

Item

Amount

Category

Owner

Status

Paper

12

Supplies

Alex

Complete

Pens

8

Supplies

Sam

Complete

Desk lamp

45

Equipment

Jordan

Planned

Notebook

15

Supplies

Alex

Planned

Storage box

20

Equipment

Sam

In progress

Enter Total in A7 and =SUM(B2:B6) in B7. The initial total is 100. Column widths, colors, and number formatting are presentation choices; the values and cell addresses are what the exercise depends on.

Press Ctrl+Shift+S to choose a practice folder and save as Riverside-Expense-Tracker.xlsx. Reopen this named copy before following the exercise above. Keep your original documents separate.

Ulet

Kancelářský balík pro každodenní práci na jednom místě.

Zobrazit funkce