Fill blank cells

How can I automatically fill blank cells with placeholders?

give an example of what you want
what data is in the cells?
and What data do you want if empty?

Select your range.
Edit|goto|special
Blanks

Type your placeholder value and hit ctrl-enter.

Debra Dalgleish explains a variation of this (with pictures!) at:
http://www.contextures.com/xlDataEntry02.html

jenny wrote:
>
> How can I automatically fill blank cells with placeholders?

--

Dave Peterson

Thanks, it worked great.

"Dave Peterson" wrote:

> Select your range.
> Edit|goto|special
> Blanks
>
> Type your placeholder value and hit ctrl-enter.
>
> Debra Dalgleish explains a variation of this (with pictures!) at:
> http://www.contextures.com/xlDataEntry02.html
>
> jenny wrote:
> >
> > How can I automatically fill blank cells with placeholders?
>
> --
>
> Dave Peterson
>