paste special + skip blank

[lezawang]

Hi
I wanted to use paste special option. So I click on a cell which has value A1=2. I want to paste this cell on a column, so I select Paste special then "Add" then "Skip blanks". but excel added number 2 to all cells including the blank cells? Why is that? Thank you.

 

[sheetspread]

Skip blanks means don't paste blank cells over filled cells, to add only to filled cells copy then use F5(Goto)-special-constants(or formulas) then paste special.

 

[lezawang]

"do not paste blank cell over filled cells" <--- sorry i could not get that?

 

[sheetspread]

Lets say I have:

Excel 2010
	C	D	E
3	5		1
4	6		4
5			9
6			16
7			25
8	9		36
9			49
10			64
11	11		81
Sheet3

If I copy the first range onto the second, choosing "Skip Blanks" I get:

Excel 2010
	C	D	E
3	5		5
4	6		6
5			9
6			16
7			25
8	9		9
9			49
10			64
11	11		11
Sheet3

So the blank cells didn't paste over.


Now if I have:

Excel 2010
	A	B	C
3			5
4	2		6
5
6
7
8			9
9
10
11			11
Sheet3

I can paste the 2 to the nonblanks with F5 to get:

Excel 2010
	A	B	C
3			7
4	2		8
5
6
7
8			11
9
10
11			13
Sheet3

"Skip Blanks" isn't used here because the copy range has no blanks