In this video, I will show you a super-fast way to select all the blank cells in a data range and fill these blank cells with any value/formula you want.

To select all the blank cells in a data range, you can use the Go To Special dialog box. In the Go To Special dialog box, there is an option called Blank - which instantly selects all the blank cells at one go.

Once you have all the blank cells selected, you can fill all these at one go by first typing the content that you want in these blank cells and then using Control + Enter (hold the control key and press the Enter key).

Doing this would fill the content in the active cell in all the blank cells, that were already selected.

This video is a part of my 'Excel is two-minute' series, where I share simple and quick tips to help you speed up your work and be more efficient


Free Excel Course - [ Ссылка ]
Paid Online Training - [ Ссылка ]
Best Excel Books: [ Ссылка ]

⚙️ Gear I Recommend:
Camera - [ Ссылка ]
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - [ Ссылка ]
Wireless Mic: [ Ссылка ]
Lighting - [ Ссылка ]

Subscribe to get awesome Excel Tips every week: [ Ссылка ]

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

свернуть