The formatting of text in Microsoft Excel is very similar to the layout in Microsoft Word.
The commands in the Font group and the Alignment group are almost identical to the commands in the Font group and the Paragraph group in Microsoft Word.
To format cells or cell ranges, we first select the cell (s).
If this is not selected, select the Home tab in the ribbon.
To set the Font Size we click the black arrow pointing downwards:
Since Excel 2007 we have the option “Live examples”.
When you hover over the different font sizes with the mouse pointer, an example is automatically displayed in the worksheet.
Click a font size when you are satisfied.
The same Live Preview option also works with the font, fill color, and font color commands.
We also have the commands Bold, Italic, Underline, Larger font size and Smaller font size.
With the Underline command we have two options when we press the arrow:
just underline (what the standard setting is) and double underline.
Clicking the “Larger font size” and “Smaller font size” buttons increases the font size by 2 pixels.
Next to the group “Font” we find the group “Alignment” with 11 command buttons.
The first three are “Top Align”, “Align Middle”, and “Align Bottom”.
We use this to align the text vertically.
Depending on the height of the row, these will align the text above, middle, or below in the cell.
The three below are “Align left”, “Center” and “Align right”.
We use this to align the text horizontally, in our cell.
The first two below are to increase or decrease the indentation of the text. Each time you click on this, the indentation increases or decreases.
Then we have the buttons “Text wrapping” and “Orientation” which we discuss in the next chapter.
When you type text into a cell that is longer than the width of the cell, the text will overflow to the adjacent cell as long as it contains no data. If this adjoining cell contains data, the data from the first cell will not be fully displayed in our spreadsheet.
A solution for this is to adjust the column width, which we have already seen in a previous lesson, but a second solution is to use the “Wrapping” button.
When we click this button, it will make all text in the cell visible by placing it in different rows.
If you click this button again, this will undo the text wrapping.