Font and Alignment | Microsoft Excel

Formatting changes can be applied to a whole worksheet, a range of cells within a worksheet, individual cells, and sometimes even text within a cell.

Using the (Format > Cells) dialog box

Shows how the selected font will appear, formatted with the options you have designated.

Font - Select a font name to change the font of the selected text. Select the options you want on the Font tab to change the appearance of the selected text.

Font Style - Change the font style of the selected text.

Size - Enter the font size for the selected text. You can type any number between 1 and 1638.

The sizes in the Size list depend on the selected font and active printer.

Underline - Select an underline type to format the selected text with an underline.

Color - Select a color from the list to change the color of the selected text or object.

If you select "Automatic" the colour will always be black ?

Normal font - You can change the text back to the default at any time.

Strikethrough - Draws a line through the selected text.

Superscript - Formats the selected text or numbers as superscript.

Subscript - Formats the selected text or numbers as subscript.

Using the Formatting toolbar

Align Left - Aligns data to the left of the cell.

Centre - Aligns data in the middle of the cell.

Align Right - Aligns data to the right of the cell.

Increase Indent - Increases the indent by 1.

Decrease Indent - Decreases the indent by 1 or removes the indent completely.

Merge and Centre - Combines 2 or more adjacent cells to create a single cell.