MS Excel - Insert Comments, Excel - Add Text Box,

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

MS Excel - Insert Comments

Adding comment to cell

Adding comment to cell helps in understanding the purpose of cell, what input it should have,etc. It helps in proper documentation

To add comment to cell select the cell and perform any of the action below

• Choose Review » Comments » New Comment
• Right-click the cell and choose Insert Comment from available options.
• Press Shift+F2

Initially comment consist of Computer's user name. You have to modify it with text for the cell comment

Modifying comment

You can modify the comment you entered before as below.

• Select the cell on which comment appears.
• Right-click the cell and choose Edit Comment from available options.
• Modify the comment

Formatting comment

You can do several formatting of comments.For formatting comment Right click on cell » Edit comment » Select comment » Right click on it » Format comment With formatting of comment you can change color, font, size,etc of the comment.

MS Excel - Add Text Box

Text Boxes

Text boxes are special graphic objects that combine text with a rectangular graphic object. Text boxes and cell comment are similar in that they display text in rectangular box but text boxes are always visible while cell comment become visible after selecting cell.

Adding text boxes

To add text box perform below actions.

• Choose Insert » Text Box » choose text box or draw it

Initially comment consist of Computer's user name. You have to modify it with text for the cell comment

Formatting text box

After you added text box, you can format text box by changing the font, font size, font style, and alignment,etc. Let us see some of the important options there.

• Fill: Specifies filling of text box like No fill,solid fill. Also specifying transparency of text box fill.
• Line Colour: Specifies the line colour and transparency of the line.
• Line Style: Specifies line style and width.
• Size: Specifies the size of the text box.
• Properties: Specifies some properties of text box.
• Text Box: Specifies text box layout , Auto-fit option and internal margins.

MS Excel - Undo Changes

Undo Changes

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

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

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 2ways.

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