View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Starguy Starguy is offline
external usenet poster
 
Posts: 6
Default Paste Special as Values: no recognition of blanks

I have a column with formulas. some formulas return blank cells and some
return data.
I copy this column and Paste Special it as Values then I select these values
and press F5 and select Blanks from Special tab options (infact I want to
remove blank cells) but it returns a msg that "No cells were found" despite
having blanks in the range. what's wrong with this.

however when I press delete on any blank cell and then use Go To command to
select blanks it then selects only that cells upon which I pressed Delete.

please explain why Excel do not recognise Pasted as values cells as blanks.