Formatting cells in Excel spreadsheets Office

Layout information from a spreadsheet cells can be changed by using the command Format Cells. When launching this command dialog box appears Format Cells

Format cells
Box contents vary depending on the selected button at the top of the window. The options are:

<br>• Number - to change the format of the numbers

<br>• Alignment - to change the type of alignment in the cell

<br>• Font - for changing fonts

<br>• Borders - for adding borders around cells

<br>• Patterns - to set the background color in the cell

<br>• Protection - to protect the information in the cell

Changing number format

Excel offers a wide range of digital formats, which are listed below:

Numeric format Examples 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 brackets, preceded by a minus sign.
Currency(Currency) $ 3,400.50 ($ 3,400.50) Default format Currency has two decimal places and dollar signs. Negative numbers appear in red and brackets.
Accounting(Accounting) $ 3,400.00 $ 978.21 This format is used to align dollar signs and decimal column. Format Accounting default contains two decimal places and a dollar symbol.
Date(Date) 11/7 Format Date includes default time and date separated by a slash (/), but you can select a different format from those available.
Time (Time) 10:00 Format T default contains two separate hour and minute points, but also can choose to display seconds, or AM and PM indicators.
Percentage(Percent) 99.50% Format Percentage default includes two decimals. Excel multiplies the value in the cell by 100 displays the result accompanied by the percentage symbol
Fraction(Fraction) Format Fraction to display numbers as a fraction.
Scientific(Science) 3.40E + 03 Format Scientific default includes two decimal places. Use this format to display numbers in scientific format.
Text 135RV90 Use the format Text to display both text and numbers in the same cell. Excel will show just exactly what you enter.
Special 02110 This format is designed for displaying postal codes, phone numbers and personal codes, so you need not 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 TypeThat can be modified. The # is a booking for a total mark, is a mark 0 booking for zero? to add a space

After setting the numeric format appropriate next steps are performed:

1. Select the cell or cell range that contains the values ​​to be formatted.

2. Apply command Format Cells. The screen will display the dialog box Format Cells.

3. Apply a button click Number.

4. From the list Category, select the number format to be used.

5. On the right side of the box is done on the selected format desired changes. For example you can set the number of decimal number to be displayed (in list Decimal places) or how negative numbers are displayed (in list Negative numbers).

6. Apply a click on the OK button, or press the key Enter. Excel will reformat selected cells according to selected options.

If you enter a date in a cell formatted with format Number, date will appear as number (serial number of the date). To solve the problem, change the cell format Number in Data.

Eliminate numerical format of a cell or range of cells is achieved by applying format General.

Number Format

Formatting toolbar contains several buttons for setting numeric formats. To use one of these buttons to select the cell or field to be formatted, then apply click on the desired button.

Cells Protection

Of option Protection the window Format Cells allows blocking selected cell, this can take effect only if the spreadsheet secure the cell is protected. This is done by going to Protection from Tools.

Sheet Protection

There are multiple protection options: they can protect current calculation sheet (Sheet), The entire file (Workbook) Or individual privileges to specific users for selective protection.

Formatting cells in Excel spreadsheets Office

About the author


Passionate about everything gadget and IT, I write with pleasure on since 2006 and I like to discover with you new things about computers and operating systems macOS, Linux, Windows, iOS and Android.

Leave a Comment