View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mr. Low Mr. Low is offline
external usenet poster
 
Posts: 505
Default Excel 2002: How to avoid pasting blanks ?

Dear Sir,

I have the following worksheet:

A B C
235 235
211 211
148 148
412 412
741 741
225 225
622 622


I wish to copy and pasting column A and B to column C simultaneously.

May I know the keyboard steps for avoiding pasting blank cells in column C ?

I try Paste Special Skip Blank but it still pasting bank cells by
overwriting earlier the cell content.


Thanks

Low


--
A36B58K641