Link to home
Start Free TrialLog in
Avatar of Rowby Goren
Rowby GorenFlag for United States of America

asked on

Copying just the formulas from one spreadsheet to another

I have a spreadsheet with forumlas in some of the columns.

The various formulas are in row "B".  

Is there a way to copy row "B" but just the formulas -- so I can paste those formulas into other spreadsheets.

The various columns each have a different formula.

Thanks

Rowby
Avatar of redmondb
redmondb
Flag of Afghanistan image

Hi, Rowby,

Copy the cells and then do a PasteSpecial Formulas. In the image below, the mouse is pointing at this.
User generated image
Regards,
Brian
Avatar of Rowby Goren

ASKER

Thanks,  Brian --

Hmmm.

I just tried that but....  the Paste Special is not working -- apparently because I'm copying it into a totally separate  spreadsheet.

Do all of the spreadsheets have to be in the same workbook for copy >> paste >special to work???

Rowby
ASKER CERTIFIED SOLUTION
Avatar of redmondb
redmondb
Flag of Afghanistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I think it was another instance of excel.  Stay tuned.  I'll open all the files in one instance.

Rowby
Hi.

Opened it all in one stance of Excel and Copy Special - Formula WORKED!

Thanks!
Great! Thanks, Rowby.