Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
clearing data from excell sheet
I want to clear all data entered into individual data cells but not the
formulas in other cells with out clearing each data cell one at a time. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
clearing data from excell sheet
If I'm understanding what you want to do, there are a couple of ways you can
do this. You can hold down your mouse and highlight the different cells you want to clear, then right click them and choose to delete, or just push delete on your keyboard.... Or you can can individually click each cell you want to clear while holding down the Ctrl button on the keyboard. When you have all of the ones highlighted that you want to clear, just push delete on your keyboard, or right-click and choose to delete. -- Have a fantastic day! Tricia LeAnn "A" wrote: I want to clear all data entered into individual data cells but not the formulas in other cells with out clearing each data cell one at a time. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
clearing data from excell sheet
Edit GoTo Special... Constants
Edit Clear Contents -- Gary''s Student - gsnu200766 "A" wrote: I want to clear all data entered into individual data cells but not the formulas in other cells with out clearing each data cell one at a time. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
clearing data from excell sheet
Edit/ Go To/ Special/ Constants
Delete -- David Biddulph "A" wrote in message ... I want to clear all data entered into individual data cells but not the formulas in other cells with out clearing each data cell one at a time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to open MS Excell 2007 Sheet in MS Excell 2000??? | New Users to Excel | |||
Clearing Old data in Pivot Tables | Excel Discussion (Misc queries) | |||
Clearing unseen data | New Users to Excel | |||
insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) | |||
VBA Question / Clearing out All Data | Excel Worksheet Functions |