Hi,
I noticed that sometimes when I filled in a cell, the respective cells on the right automatically grabs the formula from the cell above and fill in the data but sometimes I need to drag the cell manually down to fill up the data.
Example.
A1 = 1
B1 = 2
C1 = A1+B1
A2 = 2
B2 = 4
C2 = A2+B2
Sometimes after entering A2 and B2, C2 will automatically grabs C1 formula and fill in the answer. Sometimes I need to copy C1 and paste to C2 for my answer. Is there an option to do this "auto grab" function?
Bookmarks