Three Ways to Fill Blank Cells within Excel Spreadsheets

Paperwork
JohnnyLye_iStock_paperwork
Share this content
Tags
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.

About David Ringstrom

About David Ringstrom

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. His mantra is “Either you work Excel, or it works you.” David offers spreadsheet and database consulting services nationwide.

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)