I have an Excel sheet with one of the columns having around 25000 entries.
Now, I create a new sheet – say Sheet2
– and I have a simple formula like this in the first column of Sheet2
.
I went to the first row and entered
=Sheet1!C2
Now I dragged this down to the entire 25000 rows to copy the entire column from the first sheet here through this formula. Is there a better way to do it?
I tried double clicking on the + sign at the bottom right of the cell but that did not seem to work for me.