Mirosoft Excel sheets : Change the cell format in data sheet

Microsoft Excel provides several controls for dialog sheets that are useful for selecting items from a list. List boxes, combo boxes, number buttons, and scroll bars are examples of controls. For more information about Excel form controls, see general information about forms, form controls, and ActiveX controls in a worksheet.

Instead of using a calculator, use Microsoft Excel to perform mathematical operations.

How to use cells in Excel 2010?

Next, we will write the information you need to make your monthly spending budget on a spreadsheet. You will easily learn how to insert data into cells with this exercise. Also to identify rows, columns and cells in a spreadsheet; to set formats and change the color of a font or the fill of a cell.

Steps to enter data into cells

Step 1: 

Create a new book and make sure you’re on the spreadsheet you’re going to work on.

Check the topic Create and save a file in Excel 2010 if you need more information about it.

Step 2:

Once you are in the spreadsheet, select cell B2. To do this, click on the rectangle where column B and row 2 meet. You will notice that the selected cell has the thickest border and that its name appears in the upper left corner. Also, the letter of the column and the row number that are joined are highlighted.

Step 3:

Write the word  Concept in cell  B2. To do this, you can do two things:

  • Option 1: Select the cell and write the word right there. You will see that what you are writing will appear in the Formula Bar.
  • Option 2:  Select the cell and write the word in the Formula Bar. You will see that what you write will appear in the cell you have selected.

Note that …
That’s all you need to do to enter data into cells. Try both options, either is valid.

Once you enter data into a spreadsheet, you can change its format. For example, you can change the color of the letters, put decimal numbers on the numbers, or choose the appearance of the date.

How to change the format of the cells?

You can enter letters, numbers and dates in any cell of your calculation book. Also, modify the way this content looks. Click here to download the guide file for this lesson, open it and follow the instructions below.

Change the letter format:

To do this, select cells B2 , C2 and D2. Then look at the top, where it says  Font and  Alignment. Click on the highlighted buttons in the image to give bold, red color, gray background and central alignment to the words Concept, Value, and  Payment date.

Note that …
To select multiple cells, click on a cell and holding down the mouse button drag it to the other side.

Change the number format:

Step 1: To do this, right-click on cell  C4.

Step 2: Then select the Format Cells option from the drop-down menu. A dialog box will open.

Step 3: There, press the Currency button.

Step 4: Type the number zero (0) in the box next to Decimal places and click  OK.

Change the date format:

Step 1: Right-click.

Step 2: A window will open. There you select the Format Cells option from the drop-down menu.

Step 3: Press the Date button  .

Step 4: Explore the options that appear in the Type item. Click on one of them and press the OK button.

You can write simple formulas to add, divide, multiply, and subtract two or more numerical values. You can also use the Autosum feature to quickly add a series of values ​​without manually entering them in a formula. After creating a formula, you can copy it into adjacent cells, you don’t have to create the same formula over and over again.

More information on simple formulas:

All formula entries start with an equals sign ( = ). For simple formulas, just type the equal sign followed by the numerical values ​​you want to calculate and the mathematical operators you want to use: the plus sign ( + ) to add, the minus sign (  ) to subtract, the asterisk ( * ) to multiply and the backslash ( / ) to divide. Then press ENTER and Excel instantly calculates and displays the result of the formula.

For example, typing = 12.99 + 16.99 in cell C5 and pressing ENTER, Excel calculates the result and displays 29.98 in that cell. The formula that is specified in a cell will remain visible in the formula bar and can be seen when you select the cell.

Use Autosuma

The easiest way to add a sum formula to the spreadsheet is to use Autosuma. Select an empty cell directly above or below the range you want to sum, and on the Home or Formula tab of the ribbon, click Autosum > Sum . Autosuma will automatically detect the range to be added and create the formula. This also works horizontally if you select a cell to the left or right of the range you want to add.

In the illustration above, it shows how the Autosuma function automatically detects cells B2: B5 as the sum range. All you need to do is press Enter to confirm. If you need to add or exclude more cells, you can hold down Shift + the arrow key of your choice until the selection matches what you want. Press Enter to complete the task.

IntelliSense Function Guide: The SUMA floating label (number1, [number2], …) below the function in your IntelliSense guide. If you click SUM or the function name, it will change to a blue hyperlink that will direct you to the Help topic for that function. If you click the individual elements of the function, their representative elements in the formula will be highlighted. In this case only B2: B5 would be highlighted since there is only one number reference in this formula. The IntelliSense tag will appear in any function.

Avoid rewriting the same formula

After creating a formula, you can copy it to other cells, no need to retype the same formula. You can copy the formula or use the fill handle to copy the formula into adjacent cells.

For example, when the formula in cell B6 is copied to C6, the formula in the cell automatically changes to update the cell references in column C.