Formatting cells in Excel spreadsheets
AdvertisementsAppearance information in spreadsheet cells can be modified by either using Format Cells. When launching this command appears on screen dialog box Format Cells
Box contents vary depending on the selected button in the upper window. The options are:
• Number - to change number format
• Alignment - to change the alignment of cell type
• Are - for changing fonts
• Borders - for adding borders around cells
• Patterns - for setting the background color in cell
• Protection - to protect information from cell
Changing the number format
Excel ofera formate or paddle long numerice, which are presented below:
| Format numeric | Example | Description |
| General | 10.7 (-10.7) | Excel displays the value as entered. |
| Number | 3400.50(-120.39) | Default format Number has two decimal places. Negative numbers appear in red and in brackets, preceded by a minus sign. |
| Currency(Currency) | $3,400.50 ($3,400.50) | Default format Currency has two decimal places and dollar symbol. Negative numbers appear in red and in brackets. |
| Accounting(Accountancy) | $3,400.00$978.21 | This format is used to align the dollar symbol and decimal column. Format Accounting default contains two decimal places and a dollar symbol. |
| Date(Data) | 11/7 | Format Date includes default time and day separated by a slash(/); But you can select a different format from those available. |
| Time (Now) | 10:00 | Format Time default contains two separate hour and minute points; but also can choose to display seconds, or AM and PM indicators. |
| Percentage(Percentage) | 99.50% | Format Percentage default has two decimal places. Excel multiplies the value in cell 100 displays the result accompanied by a percent sign |
| Fraction(Fraction) | ⅛ | Format Fraction can display numbers as a fraction. |
| Scientific(Scientific) | 3.40E 03 | Format Scientific default has two decimal places. Use this format for displaying numbers in scientific format. |
| Text | 135RV90 | Use the format Text to display both text and numbers, in the same cell. Excel will display exactly what you enter. |
| Special | 02110 | This format is designed to display the postal codes, phone numbers and personal codes, so is not necessary to use special characters, such as indents |
| Custom (Custom) | 00.0% | Format Custom is used to create your own digital format. You can use formatting codes list Type, changeable. The symbol # Reservation is a marker for a number, 0 Reservation is a marker for zero, ? to add space |
When determining appropriate numeric format, following steps are performed:
1. Select the cell or cell range containing the values to be formatted.
2. If APLICA controls Format, Cells. The screen will display the dialog box Format Cells.
3. Just a click on Number.
4. This list Category, select the number format to be used.
5. On the right side of the box is made desired changes on the selected format. For example you can set the number of decimal places that will be displayed (in list Decimal places), or how negative numbers are displayed (in list Negative numbers).
6. Just a click on OK, se sau apasa tasta Enter. Excel will reformat the selected cells according to options chosen.
If you enter a date into a cell formatted with format Number, date will appear in number (serial number of the date). To solve the problem, change the cell format Number in Date.
Elimination of numerical format of a cell or range of cells is achieved by applying format General.
Formatting toolbar contains several buttons for setting numeric formats. To use one of these buttons, select the cell or area to be formatted, Then apply click on the desired button.
Of option Protection to ferestrei Format Cells allows the selected cell block, this may take effect only if secured the spreadsheet cell is protected. This is done by going to Protection of Tools.
Protection options are multiple: current sheet can protect computer (Sheet), entire file Excel (Workbook)individual privileges to specific users or for selective protection.
Advertisements
