View Single Post
  #3   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

It was stated I want values!
--

Best Regards,
FARAZ A. QURESHI


"Gary''s Student" wrote:

In the new workbook, do you want the formulas replaced by blanks or by the
values from the old workbook?
--
Gary''s Student - gsnu200811


"FARAZ QURESHI" wrote:

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