Functions

Hello Victoria

Hope you enjoyed your Excel training with BEST STL.

Thank you for your question regarding hyperlinking and formulas.

When you use hyperlinking, you can specify where to link to, even within the same workbook.
So, if you were to create a formula or enter some text into a cell, you could then create a hyperlink from that cell to any other cell ni that workbook, another workbook, website or a completely different document type altogether.

To enter a hyperlink, use INSERT > HYPERLINK.

You can also use the shortcut CTRL +K to insert a hyperlink into a cell.

Hope that answers your question.

Regards

Richard
Microsoft Office Specialist Trainer