Forum Discussion
mechineni09
Mar 13, 2025Copper Contributor
How to fill in the blank cells without scrolling in excel after applying filter.
How to fill the blank cells without scrolling in excel after applying filter. Here, I am using XLOOKUP to fill the blank cells from a dataset.
nabilmourad
Mar 14, 2025MVP
I wish you provided some sample data to be able to help you precisely.
But here is a general answer:
On the Home Tab ►Click on Find and Select ► Go To Special
In the dialog box select Blanks ► Hit OK
Start typing without any further clicking
When done ► Hit CTRL + Enter
Hope that helps