Journal of Accountancy Large Logo
ShareThis
|
Technology

Transfer An Excel Formula From One Worksheet To Another

By Stanley Zarowin
November 2004

Q. I know how to link data from a cell in one worksheet to another worksheet, but how can I transfer a formula?

A. To transfer data, enter them in sheet 1, go to sheet 2 and the cell in which you want the linked number to appear and enter the equal ( = ) sign. Then go back to sheet 1 and the source cell and press Enter.

Now, to transfer a formula: Assume the formula is in sheet 1, cell A1. Highlight A1, Copy (Ctrl+C) it, go to the cell in sheet 2 where you want the formula to go and Paste (Ctrl+V) it. Excel will adjust the formula to =Sheet1!A1.

View CommentsView Comments   |  
Add CommentsAdd Comment   |   ShareThis

RELATED TOPICS

CPE Direct articles Web-exclusive content
AICPA Logo Copyright © 2013 American Institute of Certified Public Accountants. All rights reserved.
Reliable. Resourceful. Respected. (Tagline)