Excel Cells

format excel cells |  changing Number  format | Alignment format | Font format | Border format | Fill format |  cell protection

A Cell can be used in a formula to hold different types of data like Numbers, Dates, Currency, Text…  This section will guide you how to format cells /set the cell type/create or change a cell reference…

excel cells1

Format Excel Cells

If you want to format excel cells, You can do many things for cells in excel such as: changing Number  format, Alignment format, Font format, Border format, Fill format and protection .

1. Cells Number Format

By default, the format of all cells is General number format, and General format cells have no specific number format. So if you want to set the cell content as a Number format, now we can change it via the following steps:

Step 1# Input one value “2583” into one cell, such as: B4

excel cells2

Step 2# select “B4” cell as current cell, then right-click on the B4 cell, click “Format Cells”, then “Format Cells”window appears.

excel cells3

Step 3# Select “Number” tab, then you can select one category in the category ListBox, such as you can select “Currency”, then the value will be formatted as Currency format.  The formatting result will be appear on the “Sample” section on the “Format Cells” window.

excel cells4

 Step 4# click “OK” button, let see the final result.

excel cells5

2. Alignment Format

How to Replace # Errors with Zero or Any Specific Value in Excel

If you want to align the text or content in the cell (top, bottom, center), you can set it in the “Format Cells”window or Alignment group in the Home Tab.

Step 1# Enter one value “60” into B5 Cell

excel cell alignment1

Step 2# righ-click B5 cell and then click “Format Cells” from the popup drop menu.

excel cell alignment2

Step 3# select the Alignment tab in “Format Cells” window, then you can change alignment setting via set“top””left””right” or others under Text alignment section.

excel cell alignment3

Step 4# click “ok” button, you will see that the text alignment of B5 cell will be align to center position.

excel cell alignment4

Or you can also change the alignment setting of text via alignment group in home tab. Just clicking the alignment command to align what you want to.

excel cell alignment5

3. Font Format

You can format the text to change font, font color, font size, Font style… Just follow the below steps:

Step 1# Enter into one text value into one cell, then right-click cell and click “Format Cells”, it will show “Format Cells” dialog box.  Then Select “Font” tab

excel font format 1

Step 2# To change the Font, just select one font you want to set under Font Listbox. Or click Font Drop-list in the Font group on Home tab.

excel font format 2

Step 3# To set Font size, just click Font size drop-list  in the Font group on the Home Tab or change the font size of text in “Format cells” dialog box.

excel font format 3

Step 4# There are 4 Font styles that you can set: Regular(default setting), Italic, Bold, Bold Italic. To set Font style, just click “B””I” “U” command in the Font group on the Home Tab. Also can change font style in the “Font” tab of “Format Cells” dialog box.

excel font format 4

4. Border Format

You can draw a border around a cell or range cells. The below steps will show you how to draw a border.

Step 1#  select one cell and then right-click on the cell

Step 2#  select “Format Cells” from the drop list. Then “Format Cells” dialog box appears.

Step3# select the“border” tab , then select your line style and the borders that you want to draw.

excel border1

Step 4# you can also click borders drop-list in the Font groups on the home tab.

excel border2

5. Fill Format

To change the background color of a cell, you can click the “Fill color” drop list in the Font group on the home tab or change it in “Fill”tab from “Format Cells” dialog box. See below screenshot:

excel fill format1


excel fill format2

6. Cells protection

If you want to prevent people from editing locked cells or making formatting changes, just following the below steps:

Step 1# select cells or range that you want to protect, Right-click and then click “Format Cells”, “Format Cells” dialog box appears.

Step 2# clicking “Protection”tab, just check the “Locked” checkbox. Click “OK” button.

excel cells protection1

Step 3# Go to “REVIEW” Tab, then click “Protect Sheet” button so that locking of the cells can be take effect.

excel cells protectio21

Step 4#Protect Sheet” dialog box will appear. Then  Enter one password in the password text box in “Protect Sheet”window.

excel cells protection3

Step 5# Confirmed password need to be input.

excel cells protection4

Step 6# At this time, if you want to make changes, you need to click “Unprotect Sheet” button in “REVIEW” tab, then one password need to be input in the “unprotect Sheet” diagbox.

excel cells protection5



Related Posts

How to Add Prefix or suffix to Cell
add prefix to cell113

This post will guide you how to add common prefix or suffix to all cells or the range of cells in your worksheet in Excel. How do I add the same prefix or suffix to a range of cells without ...

Quickly Insert Multiple Rows or Columns in Excel
insert multiple rows or columns13

This post will guide you how to quickly insert multiple rows or columns in your Microsoft worksheet. You will see that how to add new multiple rows or columns with shortcut or insert feature, or insert copied cells in excel. ...

Split Excel workbook into separate Files
split workbook into separate file3

This post will guide you how to split a large workbook to separate files and each worksheet should be saved as a single file. How do I split the whole workbook into several excel worksheets or single excel file. Assuming ...

How to Get the List of File Names From a Folder
get list of file names from a folder11

This post will teach you how to get the list of file names in a given directory to a worksheet in Excel. You will learn that how to use Excel to view Files and Folders in your worksheet by get ...

Find Duplicate Values in Two Columns
find duplicate cells in two columns111

This tutorial will show you how to find duplicate values in two given columns in Excel. Or How to compare two columns and find duplicate entries in Microsoft Excel worksheet. And you will learn two methods to compare columns so ...

Remove Leading and Trailing Spaces
remove leading and trailing spaces112

In this tutorial you will learn that how to remove leading or trailing spaces from a text string in a cell in Excel. This post will guide you how to delete leading or trailing spaces of all cells in a ...

Generate Random Passwords
generate random passwords5

This post will teach you how to quickly generate a random password with Formula in Excel. You can combine a series of worksheet functions to create a complex formula to generate a random password in Microsoft Excel. Generate Random Password ...

Sort by Second or Third character in a Column
sort string by second character13

This post will guide you how to sort text string by second or third character in a Column in Excel. You may be want to sort a string in a Cell by the Second or last character in excel, how ...

Copy a Cell to Clipboard with Single Click
copy a cell to clipboard3

This post will teach you how to use the Excel VBA macro code to copy a Cell to clipboard with only single click in Excel. How do I automatically copy the content of cell to Clipboard while clicking on the ...

How to Convert Positive Numbers to Negative
change positive to negative 112

This tutorial will teach you how to change positive numbers to negative with Paste special multiply operation in excel. How to convert positive number to negative or how to reverse the number signs with VBA code in Excel. Convert Positive ...