In this article, you’ll learn a trick to select all empty cells in an Excel spreadsheet at once and fill in blanks with value above / below, with zero or any other value. Continue reading
by Ekaterina Bespalaya, updated on
In this article, you’ll learn a trick to select all empty cells in an Excel spreadsheet at once and fill in blanks with value above / below, with zero or any other value. Continue reading
Comments page 8. Total comments: 201
how to fill blank cells with combined numerical and letters ex(kiran123 bellow rows
copy cells with values just above it in column with blanks and muliptle values in between
smith
jone
daid
Thank for such valueable post
Love it helps in studies and information gave me confidence for test
Very helpful very good much help ful love it
Thank you so much!
Hi,
Excel formula to fill in blank cells with value above / below.
Doing the steps referring with the value above is working. However, if I do the same with value below it is not working. Can anyone help? I want the below value to be copied on the above blank cells.
Thanks in Advance.
Thanks... It saved me lot of time
How do I fill up?
@ashwith
It looks like all the cells are not in the DATE format. Format the required cells/column/row as DATE and select the required format on the drop down menu. If leading zeros are required in the date, you can FORMAT CELLS>NUMBERS>CUSTOM, then input dd/mm/yyyy (or mm/dd/yyyy)under "Type:"
this is great, but how we can apply for date , i got below type answer, kindly solve
06/04/2015
06/04/2015
06/04/2015
42100
06/04/2015
42100
06/04/2015
42100
06/04/2015
42100
06/04/2015
42100
06/04/2015
06/04/2015
07/04/2015
42101
07/04/2015
07/04/2015
42101
07/04/2015
07/04/2015
you are my hero! ..... thaaaaaaaanks
Thank you very very much.
Has anyone ran into the issues of hitting "crtl enter" and it doe not autofill the cells? I have ran this exact formula before but today it is not working?
You are amazing man.
You don't know that you have saved my 3 days of work and I have done that work in 5 minutes. Great job man.. God bless you.
:-)
i need formula
2.254+152.00
plz mere ko point ke above wali value ko hatane ka formula chayiye
It is too late. However, try rounding off values. Point ke above wali value hat jaayenge.
Thank you very much. You just saved me many hours
This was a huge help! Thank you!
Thanks a lot you made my day
It's the perfect one what im finding for and got it. Thanks
Find and Replace. Genius shortcut for what I needed. Thanks
The Best Option...
This worked, thanks!
Thank you so much. Fantastic.
thank you so much you made my day
I understand Good
I press f2 on my mac when trying to replace the empty numbers with zeros and it only leads me to brighten my screen.
Hello Maria,
Most likely you need to press the fn key at the same time, i.e. use the keyboard combination fn + F2.
When I do this method of the '=b2' it simply enters b2 all the way down. What did I do wrong?
You must be directly entering the command by "Enter" command, make sure you are using "Cntrl+Enter" at the same time, your issue will be solved
Hi,
I know its a bit late after the fact but the issue is your column must be in 'text' format, same thing happened to me I changed it to 'General' and the above steps worked correctly.
You just made my day!!
Now I can fill all those blank cells and make the Pivot Table work with "sum" instead of "count" which is so annoying when working with large files...
Thank you so much!
Thank you Sweety! :)
Thanks a lot
you're a genius thaaaanks
how can I fill the missing data of a row with the avarage of that row?
very nice..thank you
thanks
You're goddess. Thank you very much!
Markus