View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brile Brile is offline
external usenet poster
 
Posts: 20
Default Keep formulas in an Excel template when I delete data

Hi,

this does not make them remain, do I need to do anything else, choose
Formulas etc?
--
Brile


"Roger Govier" wrote:

Hi

Press F5SpecialConstantsOKDelete

--
Regards
Roger Govier

"Brile" wrote in message
...
How do I keep the formulas in an Excel template when I delete actual data
in
the rows and columns?

For example, if i have a table containing a lot of formulas, and I would
like to make the document "clean" without the data, for someone else to
use
but keep the formulas for that person to use, how do I do that?
--
Brile