Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses london - Linking Workbooks
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel courses london - Linking Workbooks
Resolved · Low Priority · Version Standard
Reply
Linking Workbooks
Please can you remind me how to link certain cells in certain workbooks in order to get the result in a third workbook?Thanks
For upcoming training course dates see: Pricing & availability
RE: Linking Workbooks
FORMULA BASED1. Make the cell you want the result to appear in active.
2. Enter "=" to start the formula
3. Click the worksheet you want, then select the cell/s you require.
4. Add any operators (,+-*/ that you may require for the formula.
5. Commit the formula by hitting ENTER.
SINGLE CELL
1. Make the cell you want the result to appear in active.
2. Enter "=" to start the formula
3. Click the worksheet you want, then select the cell you require.
4. Commit the formula by hitting ENTER.
|
 |
|
» Forum post: Copy and paste |
If I copy and paste a spreadsheet will it copy over all the formulas in that spreadsheet?
