Formatting Cells in MS Excel
Formatting Cells in MS Excel
Formatting Cells is one of the most power and attractive features of MS Excel. This feature provides the user with the flexibility and control over the data formatting. Formatting Cells cover the type of data, formatting, alignments, borders, shading etc.
Formatting Cells options are quite extensive and so this tutorial will be covering the options that are generally used.
Applying Number format
To apply a number format to a cell or a range of cell, select the desired range.
On the main Home tab, under the Number group, Click on the combo box showing “General” value and select “Number” from the list as shown in the figure below.
Applying Currency format
To apply a currency format to a cell or a range of cell, select the desired range.
On the main Home tab, under the Number group, Click on the combo box showing “General” value and select “Currency” from the list as shown in the figure below.
Applying Percentage format
To apply a Percentage format to a cell or a range of cell, select the desired range.
On the main Home tab, under the Number group, Click on the combo box showing “General” value and select “Percentage” from the list as shown in the figure below.
Changing Foreground and Background of a Cell
To change the foreground or background of any cell or a range of cells, first, select the desired range.
Foreground
For changing the foreground, on main “Home” tab, under the “Font” group, click “Font Color” and select desired color from the pallete as shown in the figure below.
Background
For changing the background, on main “Home” tab, under the “Font” group, click “Fill Color” and select the desired color from the pallete as shown as shown in the figure below
Managing Borders
Applying Borders
For applying a border, on main “Home” tab, under the “Font” group, click “Border” and select the desired border style from the pallete as shown as shown in the figure below
Remove a Border
For remove border, on main “Home” tab, under the “Font” group, click “Border” and select the “No Border” style from the pallete as shown as shown in the figure below which will remove all the borders.
More Related Articles For You
- Important Terminologies in Microsoft Excel
- Working with Rows, Columns and Cells in Excel
- Working with Ranges in MS Excel
- Formulas and Functions in MS Excel
- Ribbon in MS Excel
- Workbook in MS Excel
- Templates in MS Excel
- Data Validation in MS Excel
- Excel Keyboard Shortcuts
- Protecting a Workbook in MS Excel with Password
- Print Gridlines in an Excel Worksheet
- How to Share MS Excel Data
- Count and Sum Function in Excel
- Logical Functions in Excel
- Date and Time Function in Excel
- Worksheet in Excel
- Find and Select in Excel
- Cell References in Excel