Home

Tip Format & Sum currency data in a Spreadsheet

Learn how to quickly format data to currency and calculate the total in a Spread Sheet

How to Format Data (currency format)

1) Enter the data into the cells, then using your mouse left-click and drag across the cells to highlight the data

Cartoon Image

2) Using the mouse, right-click on the highlighted data and select Format Cells.

Cartoon Image

3) The Format Cells box will appear. In the Number tab, select Currency and choose decimal places (2), then click OK. Your data will be formatted to appear as currency.

Cartoon Image

How to sum data (Autosum)

4) Using the mouse, left-click and drag across the three blank cells directly underneath the data to select them

Cartoon Image

5) Click the AutoSum button (located in the Editing command box on the Home tab). The will quickly sum the data in the column above and put the total in the cell below.

Cartoon Image

Download this Tip as a PDF document;Tip Format & Sum currency data in a Spreadsheet

More IT Tips