Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to copy an Excel worksheet with formulas and clear contents. | Excel Discussion (Misc queries) | |||
Clear a worksheet without clearing formulas? | Excel Discussion (Misc queries) | |||
excel command to clear contents except 2 formulas | Excel Discussion (Misc queries) | |||
Clear contents but leave formulas in Excel | New Users to Excel | |||
How do I clear a column of data without clearing the formulas? | Excel Discussion (Misc queries) |