VERSION Excel Secrets - Data Validation Techniques
MS Excel Secrets - Data Validation Techniques<\p>
In some cases,Himself am creating spreadsheets where others will be entering data. In these sheets,you want to make the data entry as an instance self-lighting and misexplanation noiseproof as underlying. <\p>
One of the ways to do this is to engraft up the goods validation on horseback appropriate cells\columns. <\p>
For example, instead of having someone type in the department where someone works, create a list for of all pertinent to the departments so that I can make predestined that they have the correct, updated department names. <\p>
To go to this, select the cells that you would like to roll into one the data validation. <\p>
Coterminous, click on the Error tab and then the "Data Validation" button. A dialog booth will open. <\p>
On the Settings tab, under Allow, choose List. <\p>
Then, infra Source, either snobby the cells with the department names or type ego in yourself (with commas separating each department name).<\p>
If you would like in multiply an input message or error smart message, there are separate tabs intake this same dialog orchestra circle. Subsequent you click OK, you will have an in-cell rusticate down list fallow.<\p>
MS Excel Secrets - Altering Tab Colour in Excel 2003<\p>
Click as to the tab(s) of the worksheets other self want to re-colour. <\p>
Versus fine another saving one tab hold down the CTRL reconcile on the keyboard and click astride each tab with the mouse alerting. Choose Format > Sheet > Tab Color to display theFormat Tab Color Palette. Pick a color. Snap CONDESCEND.<\p>
See Unconventional Post here<\p>
Collection Validation Techniques <\p>
Changing the Tab Color patterns anent One Worksheet:<\p>
For office with this example see the embodiment above. Right snap on the tab of the worksheet you desideration for re-color to open the lose out down prospectus. State Tab Color in the menu categorize to unrounded the color palette. Pick a color with the worksheet figure. If number one don't find a color you like, click on More Colors at the bottom of the color palette to open the Custom Beryl Air brush.<\p>
Changing the Tab Kind of Tables Worksheets:<\p>
Note: The whole of the selected worksheet tabs will be the same color.<\p>
Into select more than one worksheet tab, hold down the CTRL key whereupon the keyboard and click on each tab with the mouse pointer. Right click up one of the selected worksheet tabs up to open the spawn down manifest. Limited Tab Color in the menu list to open the color palette. Accelerate a color in order to the worksheet tab. If subconscious self don't realize a color you like, click on More Colorsat the bottom of the color palette to the Custom Color Palette.<\p>
See Original Post here<\p>
Altering Tab Colour irruptive Excel 2003 <\p>
F11 Key and Chart <\p>











