• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 37
  • Last Modified:

Excel Problem

Hello Experts,
I have an excel spread sheet that has blank valuesr.  This column also has other values in it that I do not want over written.  I would like to put a value into all of the blank fields of this column.  Can someone assist?  Thanks in advance.

Steve Eckerman
Steve Eckerman
1 Solution
NorieVBA ExpertCommented:

Any particular value(s) you want to replace the blanks with?
Ejgil HedegaardCommented:
Apply autofilter, and filter on blanks for the column.
Type the value in the first cell, and copy to the others.
Then remove the filter.
Wayne Taylor (webtubbs)Commented:
1. In an empty cell anywhere in your worksheet, enter the value you wish to be in the blank cells in the column.
2. Copy that value
3. Select the column with the blank cells
4. Press F5 on your keyboard, then click "Special"
5. Select "Blanks" and click OK
6. Press Ctrl+V to paste the value into the selected blank cells.
Steve EckermanSystems AdministratorAuthor Commented:
This worked perfectly!  Thank you Experts for your comments and solutions.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now