Saturday, February 26, 2011

How to Link Cell Sheets in Excel 2007


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.

Blogger news