Monday, August 22, 2011

How to Format a Web Address Hyperlink in Excel 2010


1. Right click the cell that you want to format and click 'Hyperlink.' The 'Insert Hyperlink' dialog box appears on your screen.
2. Click 'Existing File or Web Page' under 'Link to.' Enter the web address in the 'Address' field.
3. Enter the text you want Excel to display in the cell in the 'Text to display' box.
4. Click the 'OK' button.
5. Click the 'Home' tab and click 'Cell Styles' in the 'Styles' group.
6. Right click 'Hyperlink' from the 'Data and Model' heading.
7. Click 'Modify' and then 'Format' (in the 'Style' dialog box). Change the hyperlink's font, style, size and color on the 'Font' tab. To change the cell alignment of the hyperlink, click the 'Alignment' tab. Click the 'Fill' tab to add a background color to the cell.
8. Click the 'OK' button to apply the changes.

Blogger news