| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data validation
Hi,
I'm reusing a worksheet with a mixture of data validation and data entry cells. The data validation is based on a list and the first cell in the list is blank. Because the worksheet has been filled in I would like to re-set all data without removing the text in the non-data val cells in between. Is there any quick way to do this? Cheers Diddy |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data validation
Hit Ctrl+G to bring up the Go-to dialogue. Click special, then click "data
validation - all". Hit delete to clear cells. -- Best Regards, Luke M "Diddy" wrote in message ... Hi, I'm reusing a worksheet with a mixture of data validation and data entry cells. The data validation is based on a list and the first cell in the list is blank. Because the worksheet has been filled in I would like to re-set all data without removing the text in the non-data val cells in between. Is there any quick way to do this? Cheers Diddy |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data validation
Thank you Luke,
I took Protection off and it worked beautifully! "Luke M" wrote: Hit Ctrl+G to bring up the Go-to dialogue. Click special, then click "data validation - all". Hit delete to clear cells. -- Best Regards, Luke M "Diddy" wrote in message ... Hi, I'm reusing a worksheet with a mixture of data validation and data entry cells. The data validation is based on a list and the first cell in the list is blank. Because the worksheet has been filled in I would like to re-set all data without removing the text in the non-data val cells in between. Is there any quick way to do this? Cheers Diddy . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data validation
F5SpecialData ValidationOK
EditClear Contents. If your text in the "non-data val cells in between" is derived from formulas based upon the Data Val cells then that text will be removed also. To retain that text you would have to copy/paste as values before re-setting the Data Val cells to blank. Gord Dibben MS Excel MVP On Tue, 25 May 2010 06:05:01 -0700, Diddy wrote: Hi, I'm reusing a worksheet with a mixture of data validation and data entry cells. The data validation is based on a list and the first cell in the list is blank. Because the worksheet has been filled in I would like to re-set all data without removing the text in the non-data val cells in between. Is there any quick way to do this? Cheers Diddy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| Data Validation Update Validation Selection | Excel Worksheet Functions | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Hybrid Mode
