rancidTaste profile image 62

How to auto fill all the blank cells with some predefined values in Microsoft Excel 2007 or 2010?


I am working a large excel file which consists many rows and many columns. There are several cells which is totally empty i,e. blank and has no value. I would fill all the blank cells with the value "N/A". How to do this quickly?

 

sort by best latest

Window Pain profile image55

Window Pain says

You can help the HubPages community highlight top quality content by ranking this answer up or down.

5 years ago
 |  Comment