Editing data in cells : there are 3 ways
If you want to align and format the part, you must first highlight it. The next steps are as follows:
a. Display data format format :
Go to Format -> Cells . -> Number
- Genaral : basic default type when you enter.
- Number : number type that distinguishes decimal part from
- Currency, Accounting : currency type
- Date : type of date
- Time : time type
- Percentage : percentage
- Fraction : type of fractions
- Scientific : abbreviation number type
- Text : typeface
- Special : special type
- Custom : user-format style
For example , you want to format the display date (the number displayed may differ from the actual number you entered) in the form of date / month / year: the format in Custom is dd / mm / yyyy (d-day, m - month, y-year)
b. Align, format data in cells :
Go to Format -> Cells . -> Alignment
- Text alignment : align the margin for data
- Text control :
- Right-to-left : the direction of writing text
- Orientation : orienting to display horizontal or vertical text, you can adjust the data diagonally by dragging the text axis or selecting the rotation of the text in the bottom Degrees box.
c, Font format
Go to Format -> Cells . -> Fonts
This section is similar to Word with:
- Font : font format
- Font style : italic style, bold or normal
- Size : font size format
- Underline : underlined style
- Color : font color
- Effects :
d, Format cell borders, table borders :
Go to Format -> Cells . -> Border
- Presets : pre-positioning for borders
- Border : detailed border format with upper, lower, left, right, mid-stroke and horizontal strokes.
- Line : contour type
If you want to format the color for the cell , go to Format -> Cells . -> Patterns and choose the color.
In addition, if you want to format quickly, you can use the functions available on the Formatting toolbar to format
2, Delete the entire format did
In case you have finished formatting but want to delete the format to redo (delete without losing data) you do the following:
- Black out all data that you want to remove
- Go to Edit -> Clear -> Format
3, How to calculate and copy formulas in Excel
a, Enter the calculation formula :
If you want to calculate the value of any cell, use that cell's address to calculate
For example: If you want to add 2 numbers at address B5 and C5 address together, the formula in the cell should result in = C5 + B5 (not necessarily remember the address of the cells, you just need to type the equal sign (=) then click on cell B5, type the plus sign (+) and then click on cell C5, then press Enter to get the result)
b, Copy the formula :
If with a table like the image above, you don't have to calculate the sum for each row of the table, just enter the formula in a single cell in the result column. After entering the formula and press Enter, place your mouse in the lower right corner of the cell (the mouse pointer appears as a black plus sign) and hold the left mouse button up or down (you can drag across the row if results are in horizontal rows)
------------------------
Practical exercise