Microsoft Excel offers two ways to link sheets in a workbook: hyperlinks and macros. Hyperlinks use the program's ribbon controls, while macros use Visual Basic code.

While there is a way for you to open two Excel workbooks at the same time, you can also open multiple spreadsheets in separate windows. Learn how!