In this training example, we will show you how to insert and change the appearance of information in an Excel Worksheet.
In order to manipulate data in Excel, you must first know how to move around in Excel. You can determine where you are at in an
Excel worksheet by looking at the cell name displayed in the name box. In the graphic below, you can see that the cursor is in the A1
While in an Excel worksheet, you can move from cell to cell in two ways.
1. The first is by simply using your mouse to position the cursor in the cell you desire and clicking on it.
2. The second method is to depress your Tab key, which will move your cursor to the next cell to the right. You may also use
your arrow keys to move to desired cells.
When you wish to input data, place your cursor in the desired cell and type the information in the cell. In our example, we will insert
the title “Item” and “Price” in cells A1 and B1.
Now, add additional data as listed below into your worksheet.
A2 Bed B2 1,099.00
A3 Dresser B3 599.99
A4 Total B4 1,698.99
Your worksheet should look like this.
If when inputting your data, the numbers do not appear as you expect them to, it is because the format of the cells is incorrect. In the
example below, the cells were formatted for a date, rather than currency. The correct figures were typed in the cells, but when you
depress the return key, they appeared in the cells incorrectly. To correct the problem, follow the steps below to format the cells to
Once you have your data entered, you can change its appearance by formatting it. In this example, we will format the figures to
currency. To do so, first, click in Cell B2, and while still depressing your mouse button, drag your cursor to cell B3 and Cell B4. This
will highlight or select the desired cells. Then click on the $ sign in the format menu bar.
You can also change the width of the columns in your worksheet. To do so, position your cursor on the line dividing the columns in
the column heading row. Your cursor will change in appearance from a white plus sign to a skinnier black cross with two arrows.
When your cursor changes appearance, double click and the column will resize to the appropriate size to match cell contents.
We will now change the color of the text of the entered data. Highlight the data you desire to change by placing your mouse in the
appropriate cell, clicking it and dragging it to all desired cells. In this example, place your cursor on the word “Total” in A4, click and
drag it to B4. Then select the font color icon from the formatting toolbar and choose the desired color by using the drop down
Next, we will bold the text in A1 and B1 cells. Place your cursor in the A1 cell, click your mouse and drag it to Cell B1. Once the
desired cells have been highlighted, move your mouse to the bold icon in the formatting toolbar and click on it.
Excel worksheets are easier to read when borders are added around the cells and the entire worksheet. This is
easily accomplished by highlighting those cells around which you wish to place a border. Once highlighted,
choose the border icon from the formatting toolbar and choose the type of border you desire.
Excel also offers the option of creating graphs/graphics to represent the data entered. In our example we will create a pie chart.
1. Select the cells that contain the data that you want to appear in the chart. If you want the column and row labels to appear in the
chart, include the cells that contain them in the selection.
2. Click Chart Wizard.
3. Follow the instructions in the Chart Wizard.
In this example, we will choose a pie chart. Follow the screen prompts to complete the pie chart.
Once you have worked through the chart wizard, you will be given the option to display the chart imbedded in your current worksheet
or on a separate worksheet.