How To Fill Blank Cells With Value Above In Excel

I want to fill blank cells with above value cells, I am using excel 2016 and and i tried highlighting range of cells and went to GOTO>Special>Blanks and when I do that I am getting no cells were found.

How else can I fill Blank Cells With Value Above In Excel?
SrivAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rgonzo1971Commented:
Hi,

Could you send a dummy?

Regards
SrivAuthor Commented:
There you go
Sample.xlsx
Rob HensonFinance AnalystCommented:
Select the table of data and apply an AutoFilter

In the relevant column then use the dropdown next to the header to select only Blanks. In the first blank row type the formula:

=A3   (assuming column A and first blank row is row 4)

Then select the remainder of that column and press Ctrl + D. This will then fill down the remainder of the column but will only populate the visible cells.

Now if you remove the AutoFilter you will see all rows populated. The column can then be copied and pasted as values to remove the formula links.
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

SrivAuthor Commented:
Rob,

When I try the above solution all the blank rows will be populated with the first non blank value. I dont want to do that, I have values in other rows in the middle and the blank columns below should be filled with Value above In the cell
Rob HensonFinance AnalystCommented:
With the filter in place, only the visible cells will be affected thus the blank cells will be populated with the formula which copies the value of the cell above and will adjust as it is copied down to refer to the cell above.
Rob HensonFinance AnalystCommented:
Also, in your sample, the only cell which is truly blank is C3. The other cells contain an apostrophe. I suspect this is a result of a conditional formula which had an option of "" eg IF(Condition,Result,"") and then the formulas have been copied and pasted as values. Those cells which had the "" result will have been overwritten with just the single apostrophe.

An AutoFilter will still recognise these as blank but the "GoTo>Specials>Blanks" does not recognise them as blank.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.