| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
delete values in several cells without deleting the formulas
I wanted to clear the values in a spreadsheet without deleting the formulas
or formatting in the spreadsheet. For example: A budget sheet made for every year, the formulas and formatting remains the same, only the values change. I tried paste special formulas....in this case, if values are present, they get copied too. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Second serie doesn't use X-as values | Charts and Charting in Excel | |||
| Format cells to display truncated values? | Excel Discussion (Misc queries) | |||
| How do I view formulas by values not by which cells they use to c. | Excel Discussion (Misc queries) | |||
| Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
| How to add a button to restore all altered cells original values? | Excel Discussion (Misc queries) | |||
Threaded Mode
