Fill Blank Cell with Previous Cell

Excel has a lot of great functions and shortcuts that will make data cleaning and manipulation easier. Not knowing these techniques will add frustration and a lot of time to your current workload and analysis. You can follow the instructions below to figure out how to fill blank cells with previous cell values.

Check out the YouTube video on replacing blank cell values

The best way to quickly do this is from the instructions below:

How to Fill Blank Cells with Previous Cell Value

  • Select data with CRTL+A or Select the Columns in which you want the blank cells to be filled
  • Press CTRL + G
  • Click on Special
  • Select Blanks, this will select all blank cells with on of those blanks highlighted.
  • In the formula bar, type = and the previous cell to the highlighted blank cell i.e =A2
  • Press CTRL + Enter, all blank cells will be formatted.

Gaelim Holland

Subscribe
Notify of
guest

3 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Vishal
Vishal
1 year ago

Thanks, It was very helpfull

Santosh
Santosh
1 year ago

Thanks a lot

Barun
Barun
9 months ago

Hi, when I do those operations, unfortunately, the cell that gets highlighted is down, e.g., in your example, perhaps row 15000. What am I not doing right?