Worksheets

A workbook can hold many worksheets (the tabs along the bottom). Formulas can reach across tabs: type the sheet name, an exclamation mark, then the cell or range, like =Jan!B2 or =SUM(Jan!B2:B4). Click the tab names below the grid to look at each sheet.