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

  

•