Excel — Fill Down Data Tip
Nov 27, 2023
Ever have a spreadsheet with annoying blanks? Blanks that you need to be filled? Take look at this time saving tip.
- Select your range of data.
2. Launch the Go To Window. Pres Ctrl + G or F5. Alternatively on the Home ribbon under “Find and Select” choose “Go To”
3. Click on “Special…” button.
4. In the Go To Special Window select “Blanks” and click OK Button.
5. This will highlight every Blank cell.
6. Begin typing this formula “= Cell Reference (enter position for one cell above) in this example that would be C2.
7. Hold down Ctrl and press Enter.
8. Your results — all blanks are filled with the content from the cell above.
