Source One Educational Society
 
Home | OS Install | MS-Office | Photoshop | SQL | Networking | HTML | Java | Model Papers | FAQ's | Health Tips | News | Jobs | Fun SMS
Excel Tutorial 2003
o BASICS
  Lesson 1
  Lesson 2
  Lesson 3
  Lesson 4
  Lesson 5
  Lesson 6
  Lesson 7
o WORKSHEET LAYOUT
  Lesson 8
  Lesson 9
  Lesson 10
  Lesson 11
  Lesson 12
  Lesson 13
o CHARTING, PRINTING AND PAGESETUP
  Lesson 14
  Lesson 15
  Lesson 16
  Lesson 17
  Lesson 18
  Lesson 19
o

ADVANCED TOPICS

  Lesson 20
  Lesson 21
  Lesson 22
   
   
 
 
Home >> MS - Office >> MS-Excel
 
Advanced Excel Topics  
   

Inserting, Viewing, and Editing Comments

To Insert a Comment:
  • Select the cell where you would like to add a comment.
  • Choose Insert Comment from the main menu.
  • Enter your comment into the text box that appears next to the selected cell.
  • Click in any other cell. The comment box will disappear
 
Notice the small, red triangle in the upper-right corner of the selected cell. This triangle indicates that there is a comment associated with the cell.
To Edit, Delete, Show, or Hide a Comment:
  • Right-click the cell with a comment.
  • Select Edit Comment, Delete Comment, or Show/Hide Comments from the menu.
 
Comments
 
To hide a comment after choosing to show it, simply right-click the cell, choose Hide Comment from the menu.
 
Look Up!
 
  • Open the Employee Sales spreadsheet.
  • Add the following comment to the cell with Jane Smith's February sales information:
    • Record Month -- Sold 19 cars!
  • Add the following comment to the cell with Thomas Morrison's June sales information:
    • Lowest monthly sales -- out sick.
  • Delete the comment associated with Jane Smith's February sales record.
  • Save and close the spreadsheet.
 

Inserting Hyperlinks

You can insert hyperlinks into a spreadsheet to access specific websites from that spreadsheet. Many businesses use hyperlinks within spreadsheets to easily link to online documents that are relevant to that specific spreadsheet.

In this example, we are working with a personal budgeting spreadsheet. We will insert a hyperlink that links to the GCFLearnFree.org® website. The site offers a tutorial on Money Basics, which includes general budgeting information.

To Insert a Hyperlink to a Website:
  • Select the cell where you would like to insert the hyperlink.
  • Select InsertHyperlink from the main menu. The Insert Hyperlink dialog box will appear.
  • Enter the text you would like to appear as your link in the Enter text to display: field.
  • Enter the website address in the Address: field at the bottom of the dialog box.
  • Click OK. The hyperlink will appear in your spreadsheet.
 
Hyper Links
 
Look Up!
 
  • Open the Monthly Budget spreadsheet.
  • Insert a hyperlink to a website of your choice.
  • Save and close the spreadsheet.
 
 
 
 
 
Home  |  Aboutus  |  Post Your Content  |  Tell a Friend  |  Contact us  |  Sitemap
© 2009 365edu. All Rights Reserved. Site by 365edu. Best view in 1024x768 resolution.