Three Ways to Fill Blank Cells within Excel Spreadsheets

Paperwork
JohnnyLye_iStock_paperwork
6
Periodically, you may have a need to fill in gaps within an Excel spreadsheet. One way to do so is to manually fill in each cell, but in this article, I'll show you three alternatives. First I'll use a formula, then Excel's Find and Replace function, and finally the often-overlooked Go To Special feature. Let's say you have a spreadsheet that looks like Figure 1. You'd like to replace the blank cells in cells B3, B6, and B7 with the words No Response. To do so, you could add this formula in cell C2, and then copy it down through cell C7:

Please Login or Register to read the full article

To access all of the content on our site, register (it's free!) or login to your existing account.

Share this content
Tags

Replies

Please login or register to join the discussion.

avatar
By Saurav
Jun 26th 2015 01:11

Liked the use double quote "" in place of if(isblank

Thanks (0)
avatar
By Mandy
Jun 26th 2015 01:11

Now I want cake.

Thanks (0)
avatar
By Barbara Newman
Jun 26th 2015 01:11

Go To Special - I love that command! Thank you

Thanks (0)
avatar
By laschwill
Jun 26th 2015 01:11

Excellent! Thank you!

Thanks (0)
avatar
By Harshi
Jun 26th 2015 01:11

Thank you :)

Thanks (0)
avatar
Sep 30th 2016 13:47

I've been working with Microsoft products for years, but have never used the Go To Special command; quite useful!! Thanks!!

Thanks (0)