Formatting Cells
·
Excel - Setting Cell Type
·
Excel - Setting Fonts
·
Excel - Text Decoration
·
Excel - Rotate Cells
·
Excel - Setting Colors
·
Excel - Text Alignments
·
Excel - Merge & Wrap
·
Excel - Borders and
Shades
Setting Cell Type in
Excel 2010
Formatting Cell
MS Excel Cell can hold different
types of data like Numbers, Currency, Dates, etc. You can set the cell type in
various ways as shown below −
·
Right Click on the cell
» Format cells » Number.
·
Click on the Ribbon from
the ribbon.
Various Cell Formats
Below are the various
cell formats.
·
General − This is the default cell format of Cell.
·
Number − This displays cell as number with
separator.
·
Currency − This displays cell as currency i.e. with
currency sign.
·
Accounting − Similar to Currency, used for accounting
purpose.
·
Date − Various date formats are available under
this like 17-09-2013, 17th-Sep-2013, etc.
·
Time − Various Time formats are available under
this, like 1.30PM, 13.30, etc.
·
Percentage − This displays cell as percentage with
decimal places like 50.00%.
·
Fraction − This displays cell as fraction like 1/4,
1/2 etc.
·
Scientific − This displays cell as exponential like
5.6E+01.
·
Text − This displays cell as normal text.
·
Special − Special formats of cell like Zip code,
Phone Number.
·
Custom − You can use custom format by using this.
Setting Fonts in Excel
2010
You can assign any of
the fonts that is installed for your printer to cells in a worksheet.
Setting Font from Home
You can set the font of
the selected text from Home » Font group » select the font.
Setting Font From Format Cell Dialogue
·
Right click on cell »
Format cells » Font Tab
·
Press Control + 1 or
Shift + Control + F
Text Decoration in
Excel 2010
You can change the text
decoration of the cell to change its look and feel.
Text Decoration
Various options are
available in Home tab of the ribbon as mentioned below.
·
Bold − It makes the text in bold by
choosing Home » Font Group » Click B or Press Control
+ B.
·
Italic − It makes the text italic by
choosing Home » Font Group » Click I or Press Control
+ I.
·
Underline − It makes the text to be underlined by
choosing Home » Font Group » Click U or Press Control
+ U.
·
Double
Underline − It makes the
text highlighted as double underlined by choose Home » Font Group »
Click arrow near U » Select Double Underline.
More Text Decoration Options
There are more options
available for text decoration in Formatting cells » Font Tab » Effects cells as
mentioned below.
·
Strike-through − It strikes the text in the center
vertically.
·
Super
Script − It makes the
content to appear as a super script.
·
Sub
Script − It makes content
to appear as a sub script.
Rotate Cells in Excel
2010
You can rotate the cell
by any degree to change the orientation of the cell.
Rotating Cell from Home Tab
Click on the orientation in
the Home tab. Choose options available like Angle CounterClockwise,
Angle Clockwise, etc.
Rotating Cell from Formatting Cell
Right Click on the cell.
Choose Format cells » Alignment » Set the degree for rotation.
Setting Colors in
Excel 2010
You can change the
background color of the cell or text color.
Changing Background Color
By default the
background color of the cell is white in MS Excel. You can change it as per
your need from Home tab » Font group » Background color.
Changing Foreground Color
By default, the foreground
or text color is black in MS Excel. You can change it as per your need
from Home tab » Font group » Foreground color.
Also you can change the
foreground color by selecting the cell Right click » Format cells »
Font Tab » Color.
Text Alignments in
Excel 2010
If you don’t like the
default alignment of the cell, you can make changes in the alignment of the
cell. Below are the various ways of doing it.
Change Alignment from Home Tab
You can change the
Horizontal and vertical alignment of the cell. By default, Excel aligns numbers
to the right and text to the left. Click on the available option in the
Alignment group in Home tab to change alignment.
Change Alignment from Format Cells
Right click on the cell
and choose format cell. In format cells dialogue, choose Alignment Tab.
Select the available options from the Vertical alignment and Horizontal
alignment options.
Exploring Alignment Options
1. Horizontal Alignment − You can set horizontal alignment to
Left, Centre, Right, etc.
·
Left − Aligns the cell contents to the left
side of the cell.
·
Center − Centers the cell contents in the cell.
·
Right − Aligns the cell contents to the right
side of the cell.
·
Fill − Repeats the contents of the cell until
the cell’s width is filled.
·
Justify − Justifies the text to the left and right
of the cell. This option is applicable only if the cell is formatted as wrapped
text and uses more than one line.
2. Vertical Alignment − You can set Vertical alignment to top,
Middle, bottom, etc.
·
Top Aligns the cell contents to the top of the
cell.
·
Center Centers the cell contents vertically in the
cell.
·
Bottom Aligns the cell contents to the bottom of
the cell.
·
Justify Justifies the text vertically in the cell;
this option is applicable only if the cell is formatted as wrapped text and
uses more than one line.
Merge & Wrap in
Excel 2010
Merge Cells
MS Excel enables you to
merge two or more cells. When you merge cells, you don’t combine the contents
of the cells. Rather, you combine a group of cells into a single cell that
occupies the same space.
You can merge cells by
various ways as mentioned below.
·
Choose Merge
& Center control on the Ribbon, which is simpler. To merge cells,
select the cells that you want to merge and then click the Merge & Center
button.
·
Choose Alignment
tab of the Format Cells dialogue box to merge the cells.
Additional Options
The Home »
Alignment group » Merge & Center control contains a drop-down list
with these additional options −
·
Merge
Across − When a multi-row
range is selected, this command creates multiple merged cells — one for each
row.
·
Merge
Cells − Merges the
selected cells without applying the Center attribute.
·
Unmerge
Cells − Unmerges the
selected cells.
Wrap Text and Shrink to Fit
If the text is too wide
to fit the column width but don’t want that text to spill over into adjacent
cells, you can use either the Wrap Text option or the Shrink to Fit option to
accommodate that text.
Borders and Shades in
Excel 2010
Apply Borders
MS Excel enables you to
apply borders to the cells. For applying border, select the range of
cells Right Click » Format cells » Border Tab » Select the Border Style.
Then you can apply
border by Home Tab » Font group » Apply Borders.
Apply Shading
You can add shading to
the cell from the Home tab » Font Group » Select the Color.
Apply Formatting in
Excel 2010
Formatting Cells
In MS Excel, you can
apply formatting to the cell or range of cells by Right Click » Format
cells » Select the tab. Various tabs are available as shown below
Alternative to Placing Background
· Number − You can set the Format of the cell depending on the cell content.
· Alignment − You can set the alignment of text on this tab.
· Font − You can set the Font of text on this tab.
· Border − You can set border of cell with this tab.
· Fill − You can set fill of cell with this tab.
·
Protection − You can set cell protection option with
this tab.
