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 - trumpexcel.com/learn-excel/
Paid Online Training - trumpexcel.com/excel-training/
Best Excel Books: trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: youtube.com/user/trumpexcel?sub_confirmation=1
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
- How to FILL BLANK CELLS in Excel (with 0 or Text or Formula) ( Download)
- Excel - Fill Blank Cells with Text, N/A or 0 | Find & Replace or Go To Special ( Download)
- How To Fill Empty Cells With Zero Values in Excel | Replace Blank Cells With Zero in Excel ( Download)
- Fill Blank Cells in Excel With Value from Above ( Download)
- Quickly Fill Blank Cells in Excel with 0 - Excel Trick ( Download)
- 3 Ways to Fill Down Blank Cells in Excel ( Download)
- Fill Blank Cells In Excel With Same Text @BrainUpp ( Download)
- Fill Blank Cells With 0 or Any Text in Excel ( Download)
- Fill Empty Cells in Excel smartly😎 | Excel tricks #shorts #excel ( Download)
- How to FILL BLANK CELLS in Excel (with 0 or Text or Formula) ( Download)
- How to replace 0 with blank cells Excel ( Download)
- Quickly fill blank cells with data above in Excel ( Download)
- Excel hack to fill empty cells with 0 or text ( Download)
- Replace Blank Cells With Zeros 🔥 | Microsoft Excel Tutorial 😎 #exceltips #exceltutorial #bytetech ( Download)
- Fill blank cells with zero at once | Basic Tips & Tricks in excel ( Download)
