LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
BJM BJM is offline
external usenet poster
 
Posts: 1
Default Excel should let me clear cell contents without clearing formulas

Excel allows you to clear cell contents but it also clears formulas. We
sometimes need to clear cells to produce mockup copies of financial
statements that need to be blank in order to enter new numbers from year to
year. Too much time has to be spent in determing which cells have formulas
(which we want to keep) and which do not. We need another option to
accomplish this. We use Microsoft Office Excel 2003.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming
 
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
How to copy an Excel worksheet with formulas and clear contents. Compeer buddy Excel Discussion (Misc queries) 2 January 29th 08 05:21 PM
Clear a worksheet without clearing formulas? doodah Excel Discussion (Misc queries) 5 January 23rd 07 06:45 PM
excel command to clear contents except 2 formulas Lynda S Excel Discussion (Misc queries) 6 July 14th 06 03:06 PM
Clear contents but leave formulas in Excel ojchippy New Users to Excel 10 June 16th 06 11:05 PM
How do I clear a column of data without clearing the formulas? EllenSwarts Excel Discussion (Misc queries) 2 March 11th 05 02:09 PM


All times are GMT +1. The time now is 07:23 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"