Inserting pictures, hyperlinks and memos

Insert Picture

You can insert a picture file of choice in your worksheet.

Insert an image from your computer

  1. Click the place where you want to insert an image
  2. Click Insert-Image or click the Image icon_picture__1_.png icon on the toolbar.
  3. Click the button to search a file under Computer on the Insert Image dialog box.
  4. Browse the file you want to insert then click the Open button on the dialog box.
  5. Click the Insert button on the Insert Image dialog box.

Insert an image from a website

  1. Click the place where you want to insert an image
  2. Click Insert-Image or click the Image icon_picture__1_.png  icon on the toolbar.
  3. Click the Web Address radio button on the Insert Image dialog box.
  4. Enter web address in the Web Address field or paste the address copied from a website.
  5. Click the Insert button on the Insert Image dialog box.

 

Hyperlink

Hyperlinks are used to link between separate documents to direct readers from the current page to another or to open a new browser window to view a document.

 

Hyperlinks can be inserted into the text and will lead the readers to specific destinations.

Hyperlink to a web address

  1. Select the text to be hyperlinked.
  2. Click Insert-Hyperlink.
  3. Select Web Address on the Link To area of the Hyperlink dialog box.
  4. Enter a URL in the input field and then click OK.

Hyperlink to an email address

  1. Select the text to be hyperlinked.
  2. Click Insert-Hyperlink.
  3. Select Email on the Link To area of the Hyperlink dialog box.
  4. Enter an email address in the input field and then click OK.

Hyperlink to the current document

  1. Select the text to be hyperlinked.
  2. Click Insert-Hyperlink.
  3. Select Current Document on the Link To area of the Hyperlink dialog box.
  4. Select one of the existing sheets in the list and then click OK.

 

Memo

You can type comments about complicated calculations to provide information about cells. You can insert one memo for one cell.

Insert Memo

  1. Select a cell where you want to insert a memo.
  2. Click Insert-Memo.
  3. Type information inside the memo box.
    Press <Enter> to break a line in the memo box.
  4. Click anywhere in the edit window or press <Esc> to exit from the memo box.

Edit Memo

  1. Select a cell with a memo.
  2. Right click on the mouse and click Edit Comment from the context menu.
    The cursor moves on the memo box to allow you to edit the memo.
  3. Click anywhere in the edit window or press <Esc> to exit from the memo box.

You can edit, display, or delete comments using the context menus that appear when you right-click on a cell with a memo.

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.