Insert hyperlink in Excel

instagram viewer

Hyperlinks can be used in Excel to quickly access related information in other files or web pages. These links can be created both within the worksheet and to other documents. The links make day-to-day work with the Microsoft program much easier and should be easy for everyone after one or two uses.

Create a hyperlink to an existing file or web page

If you want to create a hyperlink to an existing file or webpage, follow these steps:

  1. Select the cell in the worksheet where you want the hyperlink to be created.
  2. Go to the "Insert" tab and click "Link" in the "Links" group.
  3. Under Link To, select File or Web Page.
  4. In the Address field, enter the path to the file or web page.
    5. Excel: link dropdown menu - how it works

    In the Excel spreadsheet program, you can create and link a drop-down menu so...

  5. If you want to link to a specific place in the file, click Bookmark and choose the bookmark you want.
  6. Enter the desired display text in the "Text to display" field.
  7. If desired, add a "Tooltip".
  8. Click "OK" to create the hyperlink.

When you link to one of your files, it shows Excel Sometimes you get a security warning when you open it. There is no need to panic here. If you trust the source, you can click Yes and continue.

Create a hyperlink to a new file

To create a hyperlink to a new file, follow these steps:

  1. Select the cell in the worksheet where you want the hyperlink to be created.
  2. Go to the "Insert" tab and click "Link" in the "Links" group.
  3. Under "Link to," select "Create a new document."
  4. Enter a name for the new file in the New Document Name field.
  5. Enter the desired display text in the "Text to display" field.
  6. If desired, add a "Tooltip" by clicking "Tooltip" and typing the appropriate text.
  7. Select the processing time.
  8. Click "OK" to create the hyperlink.

Once you create a hyperlink, it appears as blue underlined text in the cell or range. Clicking the hyperlink will open the target.

So the same principle as when you set a hyperlink to an existing file. You can use hyperlinks to different file formats (e.g. B. excel files, Word-Files, PowerPoint presentations or PDFfiles) or create them. Hyperlinks work with anything and are the perfect tool for anyone working with multiple Microsoft Officeprograms work.

Create a hyperlink to an email address

It is also possible to set a hyperlink to an e-mail address. Here you should follow the following steps:

  1. Select the cell in the worksheet where you want the hyperlink to be created.
  2. Go to the "Insert" tab and click "Link" in the "Links" group.
  3. Under Link To, select Email Address.
  4. Enter the email address in the Email Address field.
  5. Enter the desired subject in the "Subject" field.
  6. Enter the desired display text.
  7. If desired, add a "Tooltip".
  8. Click "OK" to create the hyperlink.

In addition to Mouse you can also use the keyboard shortcut [Ctrl] + [K] to paste a hyperlink in Excel. A handy option once you get used to the options and want to work faster with Excel.

How do you remove hyperlinks?

Hyperlinks in Excel always work on the same simple principle. Removing existing hyperlinks is also not difficult.

  1. Right-click the cell in question.
  2. Choose "Remove Link" or "Remove Hyperlink" from the context menu.

Using hyperlinks in Excel can make your worksheets more efficient and user-friendly. Hyperlinks are valuable additions and make many things clearer, both for oneself and for those to whom the Excel spreadsheet is intended. They also provide the ability to quickly and easily create new files without having to leave Excel.

click fraud protection