Identify the error and correct the given formula for copying a formula of one sheet to another: =B4+D4^Sheet 1
Answers
Answered by
0
hen 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!
Similar questions
Computer Science,
7 days ago
Math,
7 days ago
History,
15 days ago
Hindi,
15 days ago
Physics,
8 months ago