Copy Paste

  • Thread starter Thread starter Jack Brackson
  • Start date Start date
J

Jack Brackson

Is there a way to convert all the formulas in a spreadsheet to values.

I tried copy-paste special-values but there are merged cells and that does
not work.

TIA.
 
Jack,

It will work as long as you don't change the selection in between copying and pasting.

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

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

Countif with indirect formulas needed 0
Formulas as Values 3
I can't copy and paste equations 0
Merging data from several Excel 2010 spreadhseets 5
Excel Linking (I think) 17
copy formula down a column and have cell references change within formula 5
Alt codes 4
How to subtract a number from a Mergefield? 0

Back
Top