You don’t have to drag a formula all the way down a column to copy it into subsequent cells? Double click the bottom right hand corner of the cell and your formula will ‘auto-fill’ down until it finds a gap in the column on the left hand side. No more scrolling down hundreds or thousands of rows!
