Page 106 - Ms Excel Note and Workbook
P. 106
MICROSOFT EXCEL NOTE AND WORKBOOK
3. Locate and select the cell where you want the value to appear. In our example, we'll
select cell C4.
4. Type the equals sign (=), the sheet name followed by an exclamation point (!), and the cell
address. In our example, we'll type ='Menu Order'!E14.
5. Press Enter on your keyboard. The value of the referenced cell will appear. Now, if the
value of cell E14 changes on the Menu Order worksheet, it will be updated
automatically on the Catering Invoice worksheet.
97 | P a g e
