Excel Trick: Fill All Blank Cells in Seconds
Learn how to quickly fill blank cells with the value above in Excel using a simple shortcut!
This Excel trick helps you clean messy data in seconds and improves your productivity in data analysis.
Steps used in this video:
1. Select your dataset
2. Press Ctrl + G --- Special --- Blanks
3. Type = then click the first previous cells from the blank cell
4. Press Ctrl + Enter
All blank cells are now filled automatically!
Save time and work smarter with Excel.
#exceltips #datacleaning #dataanalysis #excelshorts
#productivity #exceltricks