How can I automatically fill blank cells with placeholders?
D Dave Peterson Jan 7, 2005 #2 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
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
J jenny Jan 7, 2005 #3 Thanks, it worked great. Dave Peterson said: 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 Click to expand...
Thanks, it worked great. Dave Peterson said: 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 Click to expand...
