Excel Course: Cell Size and Formatting
Select one or more cells, right click on your selection, and choose "Format Cells".
From this window, you can personalize the display and formatting of the cells you have selected.
The "Number" Tab
To display a numerical value with a fixed number of decimal places, choose "Number" and set the number of decimal places:
To add a currency symbol, choose "Currency" or "Accounting":
If the cell contains a date, you can set how you would like the date to be formatted.
Customizing date 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.
The "Font" Tab
This tab allows you to customize appearance of text in the selected cells ...
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).