MS Excel PS #2: Insert a Carriage Return/Line Feed in a Cell

Problem: In an Excel Sheet cell you are typing a two paragraph text but when you hit enter key to supposedly continue encoding the next paragraph the cursor instead went to the next cell.

Solution: Use Alt+Enter. Simple, eh?

MS Excel PS #1: Place a hyperlink from one sheet cell to another sheet cell

Problem: How can I create a hyperlink to Sheet3 from a cell in Sheet1?

Solution:

(1) Use the mouse to locate the cell (say A2) where you want to put the hyperlink.

(2) Use the mouse's right button to display more options.

(3) Select the Hyperlink... option



(4) Choose the Place in This Document option at the left panel. Key in Text to display, Type the cell reference, and select a place in this document. Click OK button when done.


There you have it.

How to make graphs in Excel 2007

Here's two videos that teaches how to make graphs in MS Excel 2007

• http://www.metacafe.com/watch/1004598/learn_to_make_graphs_in_excel_2007/

• http://www.youtube.com/watch?v=8B8kFVNzlQ8