Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Madison Hughes   on Nov 29 In MS Office Category.

  
Question Answered By: Arnelle Schmidt   on Nov 29

The formulas  need to have reference to the sheet  that you copy  them from.

If the formula reads =sum(A1:C9) and it is on Sheet1 then you need to
rewrite the formula to state =sum(Sheet1!A1:C9)... assuming you are
pasting the formula in the same cell relative to Sheet1. Pasting them
anywhere else would require your formula to be =sum(Sheet1!$A$1:$C%9)

Then copy and paste will do the trick.

Or, just link the formula from the new sheet =Sheet1!B2. And, then
use the Format Painter to copy the formatting.

Share: 

 
 
Didn't find what you were looking for? Find more on Copying a range from 1 sheet to another Or get search suggestion and latest updates.


Tagged: