Excel Guides

Setting Text Attributes in Excel

When working with text in Excel, there are a number of different attributes that can be changed in order to modify the appearance of the text. These attributes include the font type, size, color, and alignment. In addition, there are a number of other options that can be changed such as the text wrapping, indentation, and spacing. All of these options can be accessed through the Font group on the Home tab.

Font Type

The first option in the Font group is the Font drop-down menu. This menu contains all of the different fonts that can be applied to selected text. To change the font, simply select the desired font from the list. The changes will take effect immediately.

Font Size

The next option in the Font group is the Font Size drop-down menu. This menu contains a list of preset font sizes that can be applied to selected text. To change the font size, simply select the desired size from the list. The changes will take effect immediately.

Font Color

The third option in the Font group is the Font Color button. This button opens a color palette from which a color can be selected for the text. To change the font color, simply click on the desired color. The changes will take effect immediately.

Text Alignment

The fourth and final option in the Font group is the Text Alignment button. This button opens a menu with options for aligning text horizontally and vertically. To change the alignment of text, simply select the desired option from the list. The changes will take effect immediately.

Other Text Options

In addition to changing the font type, size, color, and alignment, there are a number of other options that can be changed in order to modify how text appears in Excel. These options include text wrapping, indentation, and spacing.

Text Wrapping

Note:This feature is only available in Excel for Windows.


Text wrapping is a feature that allows you to control how text appears on a worksheet. By default, text is wrapped at 11 characters, but this can be changed to allow for more or less characters before wrapping occurs.
To change how text wrapping works in Excel:
  1. Click on File > Options > Advanced.
  2. In the Editing options section, change the Wrap Text after setting to whatever value you want.
  3. Click OK to save your changes.




Once you've made your changes, you'll need to apply them to your worksheet by selecting all of the cells that you want to have wrapped text and then clicking on Format > Cells > Alignment > Wrap Text.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.