Data validation
in [General]
|
From: Diddy on 25 May 2010 09:05 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
From: Luke M on 25 May 2010 09:40 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" <Diddy(a)discussions.microsoft.com> wrote in message news:1FF1035D-3083-480A-A952-152BD5C1ED71(a)microsoft.com... > 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
From: Gord Dibben on 25 May 2010 10:15 F5>Special>Data Validation>OK Edit>Clear 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 <Diddy(a)discussions.microsoft.com> 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
From: Diddy on 25 May 2010 10:31 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" <Diddy(a)discussions.microsoft.com> wrote in message > news:1FF1035D-3083-480A-A952-152BD5C1ED71(a)microsoft.com... > > 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 > > > . >
|
Pages: 1 Prev: dd/mm/yy if i change to some other format Next: format cells depending on value range |