Undo Changes

You can reverse almost every action in Excel by using the Undo command. We can undo changes in following two ways.

• From the Quick access tool-bar » Click Undo.
• Press Control + Z.

Undo actions

You can reverse the effects of the past 100 actions that you performed by executing Undo more than once. If you click the arrow on the right side of the Undo button, you see a list of the actions that you can reverse. Click an item in that list to undo that action and all the subsequent actions you performed.

Redo Changes

You can again reverse back the action done with undo in Excel by using the Redo command. We can redo changes in following two ways.

• From the Quick access tool-bar » Click Redo.
• Press Control + Y.

Redo actions

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.

Set Cell Type

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, 17^th-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.

You can assign any of the fonts that is installed for your printer to cells in a worksheet.

(toc)

Setting Font from Home

You can set the font of the selected text from Home » Font group » select the font.

Set Font from Home Tab

Setting Font From Format Cell Dialogue

• Right click on cell » Format cells » Font Tab
• Press Control + 1 or Shift + Control + F

Set Font from Format cells

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

(toc)

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.

You can rotate the cell by any degree to change the orientation of the cell.

(toc)

Rotating Cell from Home Tab

Click on the orientation in the Home tab. Choose options available like Angle CounterClockwise, Angle Clockwise, etc.

Rotate cell from Home tab

Rotating Cell from Formatting Cell

Right Click on the cell. Choose Format cells » Alignment » Set the degree for rotation.

Rotate cell from Formatting cells

You can change the background color of the cell or text color.

(toc)

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.

Change Backgropund 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.

Change Foreground Color

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

Change Foreground Color by formatting cells

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.

(toc)

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 Home Tab

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.

Change alignment from Format cells

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.