Excel Course: Cell Size and Formatting

Formatting Cells

Select one or more cells, right click on your selection, and choose "Format Cells".


format cell - excel size and formatting

From this window, you can personalize the display and formatting of the cells you have selected.

format cell window - excel size and formatting

The "Number" Tab

To display a numerical value with a fixed number of decimal places, choose "Number" and set the number of decimal places :

format number - excel size and formatting

To add a currency symbol, choose "Currency" or "Accounting" :

format currency - excel size and formatting

If the cell contains a date, you can set how you would like the date to be formatted.

cell date - excel size and formatting

Customizing date formatting :

format date - excel size and formatting

You can also set the way times, and other numbers (percentages, fractions, scientific units), etc. are displayed from this tab.

The "Alignment" Tab

You can edit the vertical/horizontal alignment of the text in a cell, its orientation, active Wrap Text (for text that extends beyond cell boundaries), etc.

diagonal text - excel size and formatting

The "Font" Tab

This tab allows you to customize appearance of text in the selected cells ...

format font - excel size and formatting

The "Border" and "Patterns" Tabs

These tabs allow you to add borders and background colors or patterns to the cell (we already covered this in the last lesson).

format patterns - excel size and formatting