| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Deleting data in cells while saving formatting & formulas
I have severl large woorkbooks/sheets that I have to reuse each month. Is there a quick and easy way to remove cell data but keep the cell formatting and formulas intact? The only way I've figured out so far is to use the backspace key in every individual cell. -- greymann19 ------------------------------------------------------------------------ greymann19's Profile: http://www.excelforum.com/member.php...o&userid=27977 View this thread: http://www.excelforum.com/showthread...hreadid=474860 |
|
#2
|
|||
|
|||
|
one way:
Edit/Goto/Special/Constants, Click OK. Type Del. In article , greymann19 wrote: I have severl large woorkbooks/sheets that I have to reuse each month. Is there a quick and easy way to remove cell data but keep the cell formatting and formulas intact? The only way I've figured out so far is to use the backspace key in every individual cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Excel could not save all the data and formatting you recently ad.. | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
