Excel Training: Basic Manipulations (2/5)

Change the size of characters

Now select cells A5 to C5:

Click on the following drop-down list and change the text size of the selected cells (size 20 for this example):

Note that if the desired size is not available in the list, you can enter it directly in the field:

You can also use the following 2 buttons to increase or decrease the text size in 1 click:

Modify the width of columns

Following the last manipulation, part of the text is no longer visible, so we are now going to widen the columns.

To modify the width of a column, place the cursor on the right edge of the column:

Then click without releasing to modify the width:

But to avoid repeating the same operation 3 times and to obtain columns of identical widths, directly select the 3 columns (by clicking on the column numbers as if they were cells):

Then modify the width of one of the columns:

This modification will then be automatically applied to the 3 selected columns:

To modify the height of rows, the operation is exactly the same as with the columns.

Bold text

Select cells A2 to C2 and click on to make the text bold:

Italic text

Select cells A6 to A10 and click on to make the text italic:

Underlined text

Keeping the same selection, now underline the text by clicking on :

To remove one of these formats, just click again on the same button.

For example, to remove the italic effect, keep the current selection and click on :

Partial text formatting

To apply one of these formats only to part of the text, double click on the cell and select the portion of text to format:

Then apply the desired format or formats: