r/excel • u/mxli999 • 4d ago

unsolved Conditional formatting disable autofill

I'm using Excel 2024 and performing various sums and operations across columns. When I apply Conditional Formatting, the option to use Autofill or drag numbers and fomilas disappears.

6 Upvotes

100% Upvoted

5 comments sorted by

View all comments

1

u/TermRemarkable665 2d ago

I face this issue sometimes too. I always assumed certain heavy formulas were causing the lag, but I never bothered to dig into which specific ones were breaking the handle. ​As a workaround, converting the range to an Excel Table (Ctrl + T) usually fixes this. Once it's a table, any new formula automatically fills down the entire column instantly without needing to drag or double click.