Pasting to Rows with with text only

I

intheway

How can I tell Excel to paste data in column A, but only to those row
that contain data? I know there is a way, but how?

Thanxs in advance...
 
F

Frank Kabel

Hi
one way:
- copy and paste your data (including formulas)
- select column A and hit F5
- choose 'Special' and check 'formulas'
- hit 'DEL'
 
Top