In this guide, we're going to show you how to fill blank cells simultaneously in Excel.
How to locate blank cells
- Begin by selecting your data, including the blank cells
- Open the Go To Special dialog by following Home > Find & Select > Go To Special in the ribbon
- Select the Blanks option
- Click OK to apply your selection
After you click the OK button you will see that only the blank cells are selected.
Populating multiple cells simultaneously
Once the blank cells are selected, do not click anywhere and type anything you want. You will see what you are typing in the first cell. After you are done with entering your data, press the Ctrl + Enter keys in your keyboard to fill blank cells simultaneously - not only the Enter key.
If you would like to apply formatting, do it right away before deselecting cells. You may want to use the Home tab in the Ribbon instead of right-clicking to avoid clicking on the wrong cell.
If you deselect after typing, you can either use Ctrl + Z to undo the process or check the How to remove all rows containing specific value in Excel article to select the cells containing a specific value.