ExcelBanter - Fill blank cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Fill blank cells (https://www.excelbanter.com/excel-discussion-misc-queries/3191-fill-blank-cells.html)

jenny

Fill blank cells

How can I automatically fill blank cells with placeholders?

Dave Peterson

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

jenny

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

All times are GMT +1. The time now is 07:22 PM.