Page 4 / 9

Formatting a Sheet

Now we will get to know the possibilities of formatting contents in Excel. You may notice that they are partly very similar to editing Word files, for example, when but there are also new things to come. Go to the sheet named Calculation in the downloaded Excel exercise workbook.

Task: Format contents

Do the following formatting tasks 1-5 in the Calculationsheet of your Excel workbook.

Set the percentage format to cell C1 according to the instructions below
Change the column widths according to what you learned earlier
Increase the height of row 10 as previously learned
Format the table (e.g., add background color for headers and align headers of numeric columns to the right)
Set two decimals in the numbers according to the instructions below

Your finished table will look like this after the task:

Nice

### Formatting cells

All the formatting options are on the Home tab.

Excelin **Aloitus**‑välilehden valintanauha

Formatting fonts

As you have selected the area to be formatting, navigate to the Font group on the Home tab, and choose an option like bolding the text (B), italics (I), underlining (U) or even a color change. Note! You can also use the next keyboard shortcuts to format the text: Ctrl+B, Ctrl+I, or Ctrl+U. These are the same format functions as in Word.

Aligning the text

The alignment you mostly need is to the right.

Because values will align to the right end of the cell, the table is easier to read when the headings of the columns are also on the right.

Aloitus-välilehdellä olevassa Numero-ryhmässä tapahtuu lukujen muotoilu

Number formats

Number formats are the thing that makes Excel superior in specific tasks when compared to, for example, Word. They are the most important formatting options in Excel.

Adding and removing decimals

Can you name a situation where adding and removing decimals would be especially useful? In Excel, you can increase and decrease the number of decimals using buttons (see image below) on the Home tab.

Desimaalien lisäys ja vähennys tapahtuu Numero-ryhmän napeista

Feel free to test the function!

Percentage formattin

Percentage formatting changes the value to percents.

Numero-ryhmän prosenttipainikkeesta saadaan prosenttimuotoilu

Info: Cell styles

With pre-made cell styles, you can quickly format selected areas.

You can find the cell styles on the Home tab, in the Styles group. When you hover your pointer over different options, you can see a preview of the style in your cells. Confirm your choice by clicking the desired style option.

Napsauttamalla Solutyylit-painikkeen alla olevaa väkästä saadaan näkyviin monenlaisia solutyylejä

Info: Removing formatting

If you want to remove all the formatting on a selected area, navigate to the Home tab, then to the Editing group, and click Clear.

Tyhjennä-painikkeen vieressä olevaa väkästä napsauttamalla saadaan auki alasvetovalikko

Clear All

Removes the content and the formatting.

Clear Formats

It only removes the formatting.

Clear Contents

Removes the content, but not formatting. It works the same as pressing Delete.

You can practice removing options on your own tab in the workbook.

Great, you made it to the end of the chapter! Are you ready to move on? Next, let's practice calculations in Excel. Now is an excellent time to take a little stretching break!

Ready to go to the next page?

Mark as complete: