Chapter 11
Connecting worksheets and workbooks
Excel in practice: seeing two worksheets of the same workbook side by side
Creating links between worksheets
Creating links to unsaved workbooks
Using the Links tab on the Trust Center
Opening workbooks with links to closed workbooks
Dealing with missing linked workbooks
Updating links when a workbook is renamed or moved
In Chapter 7, “Understanding functions,” and Chapter 8, “Using everyday functions: math, date and time, and text functions,” you find out how to set up formulas that calculate based on values within one worksheet. You can also easily connect a worksheet to several other worksheets or connect various workbooks. Excel offers easier-than-ever ways to connect ...
Get Microsoft Excel Inside Out (Office 2021 and Microsoft 365) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
