Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? -- zzzddd???? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Paste special function | Excel Discussion (Misc queries) | |||
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
Paste and Paste Special command are not enabled in Excel | Excel Worksheet Functions | |||
Paste Special Function | Excel Discussion (Misc queries) | |||
How does the PASTE.SPECIAL function work? | Excel Discussion (Misc queries) |