Copy formula to entire column (Quickest method)
In this quick tutorial we will see how to copy a formula to an entire dataset in a column (Even for very large datasets). By just doing a double click on the fill handle, you can apply a formula to thousands of rows in an instant. We also look at what should be done to your dataset as a precursor to ensure that this method works for you.
Timestamps
00:37 - Copying formula to entire column using fill handle
01:01 - Case where this method won't work
Link to the companion worksheet - https://drive.google.com/open?id=1SzP...
#excelpowertip #excelfillhandle #learn365club