Excel Paste Special Function

D

dver

I want to copy the formulae only from one row to several other rows. The
formulae are located in columns separated by data.

I have tried doing this by copying the range on a row that has both the data
and formulae
Then I selected the row cells wher I wish to paste the formulae.
Then selecting ...Paste Special ..formulas.

I find when I do this, excel pastes the contents of the non formula cells
along with the formula cells anyway.

Is there a way to paste only the formulae other than pasting the formulae in
each column down the rows?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste to excel from word - auto format problem 1
How to paste this down? 3
Merging from an Excel file with graphics 1
Avoiding auxiliary cells 0
Copy Paste 2
Select and copy only cells with values, open an app, paste into 2
Netwrokdays and EOMONTH Functions return N/A when opening Excel sh 3
Function to concatenate cells in a range 2

Top