LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
JDV JDV is offline
external usenet poster
 
Posts: 3
Default How to save formulas when creating templates

I have created a workbook containing two sheets with various formulas for my
organization. I would like to save this as a template to use for each group
however when I delete the current data in order to replace with different
data my formulas are lost. Is there any way to save the formatting and the
formulas of a workbook/worksheet without saving the current data. In
essence, I want to preserve the colors, fonts, set-up, formulas etc but not
the individual cell data.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Uniform and automated save feature... for excel (or word templates SooHunter Setting up and Configuration of Excel 3 October 6th 07 12:01 AM
Need help w/macros & formatting templates to save time SuzyQ Excel Worksheet Functions 1 December 14th 06 10:11 AM
Saving templates with links and formulas Barb1 Excel Discussion (Misc queries) 2 February 8th 05 04:13 PM
Creating templates from existing forms Marinasun Excel Discussion (Misc queries) 4 December 20th 04 08:54 PM
Creating Templates gwj248 Excel Discussion (Misc queries) 1 November 30th 04 11:42 AM


All times are GMT +1. The time now is 01:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"