Microsoft Office Tutorials and References
In Depth Information
▪ If you create a lot of workbooks that have the same layout and design, saving a
workbook with the common elements (and no data) will save you time when you create
similar workbooks in the future.
▪ You can use data in other worksheets or workbooks in your formulas. You create a link
by clicking the cell, which creates a 3-D reference to that cell.
▪ When you create a link to a cell in a table’s Totals row, hiding the Totals row causes
Excel to display a #REF! error in the cell in which you created the link.