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 FORMULAS

I have a regular daily exercise to submit a report without any formula and
therefore have to copy all the data and paste special values of the same.
Any shortcut to break such links/formulas in a single snap for:
1. The active sheet only? and
2. The whole workbook?
--
Best Regards,
FARAZ A. QURESHI