Three Ways to Fill Blank Cells within Excel Spreadsheets

istock_000001025577_large.jpg

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

Replies

Please login or register to join the discussion.

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

Thanks (0)

Now I want cake.

Thanks (0)

Go To Special - I love that command! Thank you

Thanks (0)

Excellent! Thank you!

Thanks (0)

Thank you :)

Thanks (0)