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
I went to the first row and entered
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.