MS Excel - Merge & Wrap and MS Excel - Apply Formatting

Post By: Hanan Mannan
Contact Number: Pak (+92)-321-59-95-634
-------------------------------------------------------

MS Excel - Merge & Wrap

Merge Cells

MS Excel enables you to merge two or more cells. When you merge cells, you don’t combine the contents of 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 below

• Choose Merge & Center control on the Ribbon 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 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 you have text 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.

MS Excel - Apply Formatting

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 below

Alternative to placing Background

• Number: You can Set the Format of cell depending on cell content. Find tutorial on this at MS Excel - Setting Cell Type
• Alignment:You can set alignment of text on this tab.Find tutorial on this at MS Excel - Text Alignments
• Font:You can set Font of text on this tab.Find tutorial on this at MS Excel - Setting Fonts
• Border:You can set border of cell with this tab.Find tutorial on this at MS Excel - Borders and Shades
• Fill:You can set fill of cell with this tab.Find tutorial on this at MS Excel - Borders and Shades
• Protection:You can set cell protection option with this tab.

Posted By MIrza Abdul Hannan3:09:00 pm

0

Continue Reading

MS Excel - Setting Colors and MS Excel - Text Alignments

Post By: Hanan Mannan
Contact Number: Pak (+92)-321-59-95-634
-------------------------------------------------------

MS Excel - Setting Colors

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 fromHome tab » Font group » Foreground color

Also you can change foreground color by select cell Right click » Format cells » Font Tab » Color

MS Excel - Text Alignments

If you don’t like the default alignment of cell, you can make changes in the alignment of cell.Below are various ways of doing it.

Change Alignment from Home Tab

You can change 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 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

Posted By MIrza Abdul Hannan3:04:00 pm

0

Continue Reading

MS Excel - Text Decoration and MS Excel - Rotate Cells

Post By: Hanan Mannan
Contact Number: Pak (+92)-321-59-95-634
-------------------------------------------------------

MS Excel - Text Decoration

You can change the text decoration of the cell to change its look and feel.

Text-decoration

Various options available in Home tab of the ribbon as below

• Bold: It makes text highlighted by choose Home » Font Group » Click B or Press Control + B
• Italic: It makes text italic by choose Home » Font Group » Click I or Press Control + B
• Underline: It makes text to be underlined by choose Home » Font Group » Click U or PressControl + B
• Double Underline: It makes text highlighted by choose Home » Font Group » Click arrow near U » Select Double Underline

More text-decoration options

More options available for text decoration in Formatting cells » Font Tab »Effects cells as below

Strike-through: It makes strikes the text in the centre vertically.

Super Script: It makes content to appear as super.

Sub Script: It makes content to appear as sub

more_text_decoration.jpg

MS Excel - Rotate Cells

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

Posted By MIrza Abdul Hannan3:03:00 pm

0

Continue Reading

MS Excel - Setting Cell Type and MS Excel - Setting Fonts

Post By: Hanan Mannan
Contact Number: Pak (+92)-321-59-95-634
-------------------------------------------------------

MS Excel - Setting Cell Type

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 below:

• Right Click on the cell » Format cells » Number
• Click on the Ribbon from the ribbon

Various Cell formats

Below are various cell formats.

• General:This is 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 avilable 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:This is special formats of cell like Zip code, Phone Number
• Custom:You can use custom format by using this.
  

  MS Excel - Setting Fonts
  

  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

  

• 
  

Posted By MIrza Abdul Hannan3:01:00 pm

0

Continue Reading