Transfer An Excel Formula From One Worksheet To Another

BY STANLEY ZAROWIN

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.

SPONSORED REPORT

This report details how to establish and maintain employee trust, why expenses can cause unnecessary disengagement, and how to communicate clear, concise T&E guidelines.

QUIZ

Catch these sneaky sound-alike words in your writing

Even professionals who write every day can use the wrong sound-alike word. Refresh your knowledge of common homophones by choosing the right word for these seven sentences.