Saturday, August 20, 2011

How to Insert Hyperlinks into Excel 2007 Without Changing Text Format


1. Open the saved spreadsheet.
2. Click to highlight the text where you wish to insert the hyperlink.
3. Click the Insert tab on the ribbon.
4. Click on the 'Hyperlink' button in the Links group. A dialog box entitled Insert Hyperlink will appear.
5. Click a file from the Look In list. If the hyperlink leads to a website, click the Address box and enter the URL.
6. Click the 'OK' button. The colored hyperlink appears on the selected text.
7. Change the text that contains the hyperlink, if you wish. For example, to change the hyperlink color to match the original font color of the text, click the Home tab's font commands.

Blogger news