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.