Forum Discussion
using the = sign to copy data
Hi everybody, I am a student learning Microsoft Excel, I was instructed to use a = sign in a blank cell where I want to transfer data in my second worksheet then click into the first worksheet click ...
brooklyn100gloria650 The = sign tells Excel that are going to enter a formula. If you would type something like =Sheet1!A1 it will return whatever value is cell A1 on Sheet1. If that cell is empty, it will return zero.
What you were told is just to avoid having to type the entire formula yourself. Start with the = sign, click on the other sheet name (in a tab at the bottom of the Excel window) and point at a cell with something in it and press enter. That's it.