How to Format a Web Address Hyperlink in Excel 2010

Save

A hyperlink can connect an Excel 2010 spreadsheet to a variety of external sources, including a document or picture on your computer or network, an email address, or a page on the Internet. When you insert a web address hyperlink in a cell on an Excel spreadsheet, you create a webpage shortcut for your user. There are a variety of formatting parameters that you can change for Excel 2010 hyperlinks.

  • Right click the cell that you want to format and click "Hyperlink." The "Insert Hyperlink" dialog box appears on your screen.

  • Click "Existing File or Web Page" under "Link to." Enter the web address in the "Address" field.

  • Enter the text you want Excel to display in the cell in the "Text to display" box.

  • Click the "OK" button.

  • Click the "Home" tab and click "Cell Styles" in the "Styles" group.

  • Right click "Hyperlink" from the "Data and Model" heading.

  • 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.

  • Click the "OK" button to apply the changes.

References

Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!