Go Back   Wiki NewForum > Career Forum (Documents/Tutorials/Advice) > Tech Forum & Tutorial > IT Forum > MS office Tutorials (2003 & 2007) > MS Excel 2003

Sponsored Links

MS Excel 2003 Step-by-step Excel 2003 Tutorials, Tips and Training

Reply
Views: 889 Source: CNN18.com, India-Forums, TellyChakkar, India, Times of India, Youtube, BollywoodLife, Rediff  
Thread Tools Rate Thread Display Modes
  #1  
Old 01-26-2010, 11:40 AM
seema seema is offline
Administrator
 
Join Date:
Oct 2009
Posts: 5,551
Default Topic 32: Adding and Customizing Excel Comments

Excel Comment is basically short notes that can be inserted into any cell in Excel. You cannot see it if you do not click on the comment. Itís useful for reminders, notes for others, or for cross-referencing other workbooks.

Adding comment to worksheets cells are a great way to explain the cell contents, formulas, offer tips to users or other data in the spreadsheet.
Basically there are three ways to add a comment:

1) Using Menu bar
2) Using mouse right-click
3) Using Reviewing toolbar (not explain here)

Reply With Quote
  #2  
Old 01-26-2010, 11:40 AM
seema seema is offline
Administrator
 
Join Date:
Oct 2009
Posts: 5,551
Default

To insert a Comment using menu bar method

Select the cell in which you want the comment.
From the Insert menu, click on Comment. You can see something like this:



Type your comment where the cursor is flashing.
Text will wrap automatically. If you want to start a new line, press the Enter key.
When finished, click any cell outside the comment box.

To insert a Comment using right-click method

Point to the cell in which you want the comment.
Right-click on the cell and click Insert Comment.
Type your comment where the cursor is flashing.
When finished, click any cell outside the comment box.

To display a specific Comment

Right-click the cell which contains the comment.
Choose Show/Hide Comment.
Reply With Quote
  #3  
Old 01-26-2010, 11:41 AM
seema seema is offline
Administrator
 
Join Date:
Oct 2009
Posts: 5,551
Default

To hide the Comment

Right-click the cell which contains the comment.
Choose Hide Comment.

To edit the Comment

Right-click the cell which contains the comment.
Choose Edit Comment.
Retype your comment.

To delete the Comment

Right-click the cell which contains the comment.
Choose Delete Comment.

To change the Comment Shape

Right-click the cell which contains the comment.
Choose Edit Comment.
Click on the border of the comment, to select it.
On the Drawing toolbar, click the Draw icon, point to Change AutoShape, and choose a category.
Click on a shape to select it.
When finished, click outside the comment.
Reply With Quote
  #4  
Old 01-26-2010, 11:42 AM
seema seema is offline
Administrator
 
Join Date:
Oct 2009
Posts: 5,551
Default

To change the others Comment attribute

Right-click the cell which contains the comment.
Choose Edit Comment.
Click on the border of the comment, to select it.
From the Format menu, click Comment.



From the Format Comment dialog box displayed, click on the specific tab to change the necessary settings.
You can change the comment font and background color, font size and effects, alignment, margin, etc.
When finish, click OK.
Reply With Quote
Reply

New topics in MS Excel 2003

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump


Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2018, vBulletin Solutions, Inc.