Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How To Remove Duplicates In Excel Column Or Row?
  • Understanding Pivot Tables in Excel
  • Add Outline to Data in Excel
  • How To Create Frequency Distribution in Excel
  • How to Create Gantt Chart in Excel

References

  • How to use Excel INDIRECT Function
  • MATCH function: Description, Usage, Syntax, Examples and Explanation
  • Offset in Excel
  • How to use Excel LOOKUP Function
  • How to get address of named range in Excel

Data Validations

  • Excel Data validation specific characters only
  • Excel Data validation must begin with
  • Excel Data validation unique values only
  • Excel Data validation exists in list
  • Excel Data validation whole percentage only

Wrap Text Automatically vs Manual Line Break in Excel

by

Wrap text in Excel if you want to display long text on multiple lines in a single cell.

You can format the cell so the text wraps automatically, or enter a manual line break. Data in the cell wraps to fit the column width, so if you change the column width, data wrapping adjusts automatically.

Wrap Text Automatically

1. For example, take a look at the long text string in cell A1 below. Cell B1 is empty.

Worked Example:   Strikethrough in Excel

2. On the Home tab, in the Alignment group, click Wrap Text.

Result:

3. Click on the right border of the column A header and drag the separator to increase the column width.

4. Double click the bottom border of the row 1 header to automatically adjust the row height.

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.

Worked Example:   Apply Previous Cell Styles Using Format Painter in Excel

5. Enter an extra-long text string in cell B1 and wrap the text in this cell.

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.

Worked Example:   Clean and reformat telephone numbers using SUBSTITUTE function in Excel

Result:

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.

3. Press Alt + Enter.

Result:

Note: to remove a manual line break, double click a cell, place your cursor at the beginning of the line and press Backspace.

Post navigation

Previous Post:

Superscript and Subscript in Excel

Next Post:

How to Create Gantt Chart in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • How to use Excel TRUE Function
  • IF with boolean logic in Excel
  • FALSE function: Description, Usage, Syntax, Examples and Explanation
  • TRUE function: Description, Usage, Syntax, Examples and Explanation
  • IF with wildcards in Excel

Date Time

  • DATE function: Description, Usage, Syntax, Examples and Explanation
  • Get first day of previous month in Excel
  • Generate series of dates by weekends in Excel
  • How to calculate working days left in month in Excel
  • Extract time from a date and time in Excel

Grouping

  • Categorize text with keywords in Excel
  • Map text to numbers in Excel
  • Group times into 3 hour buckets in Excel
  • Calculate conditional mode with criteria in Excel
  • Group arbitrary text values in Excel

General

  • Excel Default Templates
  • Subtotal by color in Excel
  • Cell References: Relative, Absolute and Mixed Referencing Examples
  • How to calculate percent variance in Excel
  • Currency vs Accounting Format in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning