Learn how to quickly fill blank cells in Excel using the CTRL + G shortcut. There are also other ways to fill blanks, such as using Excel features or VBA commands, but this article focuses on an efficient method for everyday work.
Fill Blank Cells
We will look at the steps for Excel on Windows and Excel on Mac separately.
Fill Blank Cells in Excel for Mac
The instructions below use Excel for Mac.
The following Excel table records product sales by salesperson.
Let’s see how to fill the blank cells with the salesperson’s name.
First, select the range that contains blank cells.
Second, on a Mac, use the shortcut below to open the Go To dialog box.
Mac: Control + G
Third, click “Special” and select “Blanks”, which refers to blank cells in Excel.
Fourth, after clicking “Blanks”, the blank cells in Excel are selected as shown below.
Fifth, follow these steps.
Type “=”, then select the cell directly above. Then press Control + Enter. The blank cells in Excel will be filled as shown below.
Fill Blank Cells in Excel for Windows
To fill blank cells on Windows, only one part of the Mac instructions above changes.
Windows: CTRL + G
In Excel for Windows, you also use the CTRL + G shortcut to fill blank cells.
Conclusion
There are about 10 ways to fill blank cells in Excel.
- Use formulas: You can fill blank cells by creating formulas based on values in other cells.
- Copy and paste: You can copy already-filled cells and paste them into blank cells.
- AutoFill: You can use AutoFill to automatically fill a series of numbers, dates, months, and more.
- Data series: You can use the data series feature to create a pattern and apply it to blank cells.
- Merge and remove duplicates: You can remove duplicate data and merge it to fill blank cells.
- Data filtering: You can filter data that meets specific conditions and apply it to blank cells.
- VLOOKUP function: You can use the VLOOKUP function to find values in another range and apply them to blank cells.
- IF function: You can use the IF function to assign values based on conditions and fill blank cells.
- Data entry forms: You can use data entry forms to fill blank cells based on values entered by users.
- Macros: You can use VBA to write and run macros that automatically fill blank cells.
Related Functions
Delete Blank Cells in Excel at Once