SMS221 Lecture 6: NPExcel2016_M07
Document Summary
Objectives: create a worksheet group, format and edit multiple worksheets at once, create cell references to other worksheets, consolidate information from multiple worksheets using 3-d references, create and print a worksheet group. Objectives: create a link to data in another workbook, create a workbook reference, learn how to edit links, insert a hyperlink in a cell, create a workbook based on an existing template, create a custom workbook template. Grouping worksheets: using multiple worksheets, makes it easier to group and summarize data, enables you to place summarized data first. Grouping worksheets: entering headings and formulas in a worksheet group, the formula is entered in the same cells in all worksheets in the group, grouped worksheets must have the exact same organization and layout (rows and columns) =sheetname!cellrange (where sheetname is the sheet"s name listed on the tab and cellrange is the reference for the cell or range in that worksheet)
