| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I clear a column of data without clearing specific cells?
I have a range of cells where the data is pulled from another spreadsheet,
then subtotaled. Is there a way to "protect" the subtotal formulas so that I can highlight the entire range, copy and paste values only but not overwrite the subtotals? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find repetition of data in cells in a column? | Excel Discussion (Misc queries) | |||
| Can I lock data into few cells in sheet and clear the rest | Excel Discussion (Misc queries) | |||
| extract specific info from cells in a column | New Users to Excel | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Comparing Cells and Displaying Data | Excel Worksheet Functions | |||
Threaded Mode
