Copy Paste

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.
 
B

Bernie Deitrick

Jack,

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

HTH,
Bernie
MS Excel MVP
 

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

Create a dynamic master file 1
Paste options button disappears 0
Copy addition formula of non-consecutive horizontal cells 2
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Date Formats 4
How to paste this down? 3
Embed the same Excel multiple times 0
Linking data in MS Word into Excel 5

Top