Format cells in Office Excel spreadsheets

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:

Number - to change the format of the numbers

Alignment - to change the type of alignment in the cell

Font - for changing fonts

Borders - for adding borders around cells

Patterns - to set the background color in the cell

Protection - to protect the information in the cell

Changing number format

Excel offers a wide palette of numerical formats, which are presented in the following table:

Numeric formatExampleDescription
General10.7 (-10.7)Excel displays the value as it is entered.
Number3400.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.21This format is used to align dollar signs and decimal column. Format Accounting default contains two decimal places and a dollar symbol.
Reserve(Date)11/7Format Reserve includes default time and date separated by a slash (/), but you can select a different format from those available.
Time (Time)10:00Format Time 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 and displays the result accompanied by the percentage symbol
Fraction(Fraction)Format Fraction to display numbers as a fraction.
Scientific(Science)3.40E + 03Format Scientific default includes two decimal places. Use this format to display numbers in scientific format.
text135RV90Use the format text to display both text and numbers in the same cell. Excel will show just exactly what you enter.
Special02110This 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 the selected cells according to the chosen 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.

Passionate about technology, I enjoy writing on since 2006. I have a rich experience in operating systems: macOS, Windows, and Linux, as well as in programming languages and blogging platforms (WordPress) and for online stores (WooCommerce, Magento, PrestaShop).

How to » Microsoft Office » Microsoft Office Excel » Format cells in Office Excel spreadsheets
Leave a Comment