Page 105 - Ms Excel Note and Workbook
P. 105
MICROSOFT EXCEL NOTE AND WORKBOOK
To reference cells across worksheets:
In our example below, we'll refer to a cell with a calculated value between two worksheets. This will
allow us to use the exact same value on two different worksheets without rewriting the formula or
copying data.
1. Locate the cell you want to reference, and note its worksheet. In our example, we want
to reference cell E14 on the Menu Order worksheet.
2. Navigate to the desired worksheet. In our example, we'll select the Catering
Invoice worksheet.
96 | P a g e
