Pasting to Rows with with text only

  • Thread starter Thread starter intheway
  • Start date Start date
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...
 
Hi
one way:
- copy and paste your data (including formulas)
- select column A and hit F5
- choose 'Special' and check 'formulas'
- hit 'DEL'
 
Back
Top