O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Working with Formulas That Reference Other Workbooks and Worksheets

Because a workbook can contain multiple worksheets, you might need to reference a cell in another worksheet or even another workbook file. No problem! As long as you follow the proper syntax, you can type a formula that contains a reference to any file.

If the cell is contained in another worksheet in the current workbook, you need to include the sheet name followed by an exclamation point (!) and then the actual address of the cell. Blank spaces are not allowed. For example, Sheet4!A75, points to cell A75 on Sheet 4 of the current workbook. Anytime you reference another worksheet in the workbook, you must include the exclamation point. If you've renamed a worksheet from its ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required