Browse » Home
Friday, June 22, 2012
How to Turn Anchor Text Into URL in Excel
1. Open Excel 2010. Click on one of the sheet tabs that appear at the bottom of the worksheet. Click into one of the cells and select the 'Insert' tab. Click 'Hyperlink.'
2. Select 'Existing File or Web Page' in the 'Link To' section.
3. Add the anchor text in the 'Text To Display' box. For example, if you are linking to cnn.com, enter 'CNN.' Type the web address in the 'Address' box. Click 'Ok' to save the changes. The hyperlink, or anchor text, appears in the Excel worksheet.