LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Excel: remove cell content but retain formula

-- I want to create a workbook to use as a form for ten novice users. This
work book will have cells that contain formulas that cause those cells to
show data from other cells.

I need to be able to delete the data from the cells without deleting the
formulas. Then the workbook can be reused in its original condition without
having to rewrite all the formulas.

Cliver6
 
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
In excel how do remove a cel's content, but keep the formula? veneziagurl Excel Discussion (Misc queries) 2 December 10th 08 07:07 PM
How to delete/change the formula of a cell and yet retain its cont Hispanglo Sam Excel Worksheet Functions 2 February 20th 07 02:17 PM
How delete formula bar and retain the computed number in a cell? Les P. Excel Worksheet Functions 3 May 13th 06 08:50 PM
How do you use EXCEL formula in properties of file (cell content) chiefcook Excel Discussion (Misc queries) 1 November 10th 05 04:53 PM
Can I retain a formula in the cell pasted to? Earl Excel Worksheet Functions 1 April 19th 05 03:33 PM


All times are GMT +1. The time now is 08:58 AM.

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"