Common terms in Excel [Format Cells PART 3]

User avatar
Administrator
Site Admin
Posts: 9
Joined: 05 Apr 2020, 03:06
Location: PTP Nagar, Trivandrum
Contact:

Common terms in Excel [Format Cells PART 3]

Postby Administrator 10 Apr 2020, 18:13

Wrap Text
Wrap text in Excel if you want to display long text on multiple lines in a single cell. Wrap text automatically or enter a manual line break.

Wrap Text Automatically
1. For example, take a look at the long text string in cell A1 below. Cell B1 is empty.
long-text-string.png
long-text-string.png (2.61 KiB) Viewed 582 times

2. On the Home tab, in the Alignment group, click Wrap Text.
click-wrap-text.png
click-wrap-text.png (4.62 KiB) Viewed 582 times

3. Click on the right border of the column A header and drag the separator to increase the column width.
change-column-width.png
change-column-width.png (3.56 KiB) Viewed 582 times

4. Double click the bottom border of the row 1 header to automatically adjust the row height.
automatically-adjust-row-height.png
automatically-adjust-row-height.png (2.77 KiB) Viewed 582 times
Note: if you manually set a row height (by clicking on the bottom border of a row header and dragging the separator), Excel does not change the row height when you click the Wrap Text button. Simply double click the bottom border of a row header to fix this.

5. Enter an extra-long text string in cell B1 and wrap the text in this cell.
extra-long-text-string.png
extra-long-text-string.png (3.96 KiB) Viewed 582 times
Note: by default, Excel aligns text to the bottom (see cell A1).

6. Select cell A1.

7. On the Home tab, in the Alignment group, click Top Align.
click-top-align.png
click-top-align.png (4.58 KiB) Viewed 582 times

Result:
top-alignment.png
top-alignment.png (3.77 KiB) Viewed 582 times

Manual Line Break
To insert a manual line break, execute the following steps.

1. For example, double click cell A1.

2. Place your cursor at the location where you want the line to break.
cursor.png
cursor.png (3.68 KiB) Viewed 582 times

3. Press Alt + Enter.

Result:
manual-line-break.png
manual-line-break.png (3.58 KiB) Viewed 582 times
Note: to remove a manual line break, double click a cell, place your cursor at the beginning of the line and press Backspace.
_____________________
Thanks & Regards
Saran BL

www.i-metrik.com

Was This Topic Useful?

Last 10 Members Who Visited This Topic

Zelenawtd, Regaembaf, User avatar Administrator

Return to “Basic Excel Training”

Who is online

Users browsing this forum: No registered users and 1 guest