, ,

36. 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 belowAlternative to Placing BackgroundNumber − You can set the Format of…
, ,

35. Formatting Cells: Applying Borders and Shades

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…
, ,

34. Formatting Cells: Merge and Wrap

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…
, ,

33. Formatting Cells: Aligning Text

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.…
, ,

32. Formatting Cells: 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…
, ,

31. Formatting Cells: 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…
, ,

30. Formatting Cells: Text Decoration

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…
, ,

29. Formatting Cells: Setting-up 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…
, ,

28. Formatting Cells: 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 shown below −Right Click on the cell » Format cells » Number. Click on the Ribbon from…