Formatting Texts in Excel

Formatting Texts in Excel



Align Text Within a Cell:

You can make your worksheets easier to read by aligning text and numbers within each cell. By default, Excel aligns numbers with the right side of the cell, and it aligns text with the left side of the cell. You can also align your data vertically within each cell. By default, Excel aligns all data with the bottom of each cell, but you can also align text with the top or middle.

Center Text Across Multiple Columns:

You can make a worksheet more visually appealing and easier to read by centering text across multiple columns. This feature is most useful when you have text in a cell that you use as a label or title for a range. By centering the text across the range, it makes it easier to see that the label or title applies to the entire range.

Rotate Text Within a Cell:

You can add visual interest to your text by slanting the text upward or downward in the cell. You can also use this technique to make a long column heading take up less horizontal space on the worksheet. Excel offers several predefined rotations, such as Angle Counterclockwise, which angles text upward at a 45-degree angle; or Rotate Text Up, which displays the text vertically with the letters running from the bottom of the cell to the top. You can also make cell text angle upward or downward by specifying the degrees of rotation.

Add a Background Color to a Range:

You can make a range stand out from the rest of the worksheet by applying a background color to the range. For example, many people apply a background color to the labels in a range, which makes it easier to differentiate the labels from the data. Perhaps the easiest way to change the background color is by applying a color from the set of 60 predefined colors that come with the workbook’s theme. You can also choose a color from Excel’s palette of standard colors, or from a custom color that you create yourself.



Please wait...

Subscribe to ExcelMOOC posts

Want to be notified when our Excel article is published? Enter your email address and name below to know all new Excel features and cool tips