View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FARAZ QURESHI FARAZ QURESHI is offline
external usenet poster
 
Posts: 553
Default REMOVING WORKBOOK'S ALL FORMULAS

I have a workbook consisting around 20 sheets. I want to copy all the same to
a new workbook with only values. Any shortcut how to remove all the formulas
instead of copypaste specialvaluesok on every sheet?
--
Best Regards,
FARAZ A. QURESHI