The drop-down list allows the selection to be changed.

What is cell formatting in ms excel. What is Format Cells in Excel. Besides finding all cells with conditional formatting you can find all cells which having the same type conditional formatting in current worksheet. The format of the cell that is currently selected is Number If you click that drop-down menu you can select a different format for the currently-selected cell.

The value shown in the drop-down is the current format for your cell. Data Formatting in excel is very useful which allows us to format the data in any way we want. In Excel the format cells is used to modify the formatting of cell numbers without modifying the actual number.

We can change font protect the file etc. Click Find Select Go To Special under Home tab. For instance you could use the simplest of formulas in a cell.

We can apply a number format 08 080 80 etc or other formatting alignment font border etc. Raw data in Excel sheets is confusing dull and difficult to read and understand without formatting. A spreadsheet provides 12 pre-defined formats.

A cell style is a defined set of formatting characteristics such as fonts and font sizes number formats cell borders and cell shading. In Excel Conditional Formatting New rule Format only cells that contain is a formatting option that applies a specific format based on the contents in a cell ie. We can change the format of data to make it as per standards or our requirements.

Please do as follows. Excel provides a few tools to make the formatting process quick and easy. The Format Cells dialog box has six tabs that allow you to change cell properties.