1. Type '=' in the cell that you want the link to occur in.
2. Click the worksheet, located at the bottom of the page, that contains the cell you want to link.
3. Select the cell you want to link and press 'Enter.' Excel then takes you back to the page where you created the link. By selecting the cell, the Excel automatically formats the 'sheetname!celladdress' for you.