Inserting and Formatting Text

Text is used mainly for column and row headings, captions, and callouts. Excel has a number of formatting features to enhance the appearance of text in your worksheet.

Formatting is also straightforward, provided that you know where to look for the commands. To resize columns and rows in Excel, either highlight the row or column and drag its border, or select Format, Column, Width or Format, Row, Height. You can also select Column Width, Best Fit to automatically set the width for headings. Do not select Best Fit until you have typed the longest line in the column.

To wrap column headings within a cell, select Format, and then Cells and then select the Wrap Text on the Alignment tab.

Note:

You can use conventional Excel commands for additional formatting.

See the Microsoft Excel User’s Guide.