HOW TO CREATE A HYPERLINK IN EXCEL AND WORD AND LINK FILES TOGETHER

How to Create a Hyperlink in Excel and Word.

Using hyperlinks is a great tool to save time and space. Learn how to create a hyperlink in Excel and Word, how to link both files together, link to external sources, edit appearance, and more. Here, we have all sorts of troubleshooting tips.

QUICK TIP: HOW TO FREEZE THE TOP ROW IN EXCEL & SPLIT WINDOW

How to freeze the top row in excel and split window

Save yourself the hassle of constantly scrolling through your data! Start using the freeze pane feature for large spreadsheets. Learn to fix your top row, column or section for quick reference and easier navigation…

HOW TO CREATE EXCEL DROP-DOWN LIST, AUTOFILL & FLASH FILL

How to Create Excel Drop-down List, AutoFill & Flash Fill

Save time with drop-down lists, AutoFill & Flash Fill. Excel can identify patterns, automatically fill cells, set up message alerts & more. These quick functions will eliminate manual data labour…