To paste formulas: do as above but choose Edit Paste Special Paste
Link


Lori wrote:

Select a blank cell in the column and then press Ctrl + [Space], Ctrl +
Shift + \ to select only non-blank cells in the column and then copy
and paste to new sheet.


Michael E. Gibson wrote:

Is there a way to have copy paste skip rows when copying a formula. Here's
what I am doing
Sheet 1 has data in
A1 data
A2 blank
A3 Data

On sheet 2 I need the data from A1 to go to A1 and the data from A3 to go
to A2 etc.
In an example Sheet 2 A1 reads "=sheet1!A1" Using copy makes the next line
read "=sheet1!A2". How can I make it skip to "=sheet1!A3" in A2?

Thanks
Mike