Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Filling Blank cell

Comment:

Hi, I have a excel sheet with 11 coloumn and with several data. But some of the cells are blank or dont have any data. I just want to fill those blank cells with a special text like "no data". Is it possible with a formula or with a macro?

Name: DerbyDad03
Date: June 13, 2008 at 06:11:30 Pacific

Reply:

Sub FillBlanks() For Each cel In ActiveSheet.UsedRange If cel = "" Then cel.Value = "No Data" Next End Sub or Sub ColorBlanksRed() For Each cel In ActiveSheet.UsedRange If cel = "" Then cel.Interior.ColorIndex = 3 Next End Sub

0

Print macro

covering up excel passwor...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: HI ive inputted loads of questionnaire results into a spreadsheet but forgot to put blank responses as a x. I now have 600 responses so is there a quick and easy formula to swap and blank cell to an X...

Summary: Hello, Does anyone know how to make Excel treat a cell as blank if there is a formula in it? I have a formula which puts the contents of one cell into another =IF((Y4>5),"",X4) In some cases the refe...

Summary: Select all the data in Column B (as this is the data you want to work with). Go to Edit, Go To, Special, Blanks. Hit = and the Up Arrow key and then hit Ctrl+Enter key. This will fill all blank cells ...