Yes, there is an easy way to autofill a formula for all 35000 rows in Excel. Here are the steps:
- Enter the formula in the first cell of the column where you want to apply it.
- Double-click on the small square at the bottom right corner of the cell. This will autofill the formula down to the last row of the adjacent column.
- If you want to autofill the formula across multiple columns, select the range of cells where you want to apply the formula.
- Hover your mouse over the bottom right corner of the last cell in the range until it turns into a small crosshair.
- Double-click on the crosshair and the formula will be autofilled across all the selected cells.
This method is much faster than dragging the formula down manually for all 35000 rows. It's a great time-saver when working with large datasets in Excel.