#validation techniques

MS Excel Secrets - Data Validation Techniques<\p>

In some cases,You am creating spreadsheets where others co-optation be entering data. Gangplank these sheets,you want headed for make the data entry as automated and botch proof as mystic. <\p>

One of the ways to do this is to knock out upstream data validation on appropriate cells\columns. <\p>

For cite a particular, instead upon having one area in the department where someone works, create a list for of all in point of the departments along these lines that I can make sure that me have the correct, updated department names. <\p>

To halt this, select the cells that you would like to adjoin the data validation. <\p>

Next, click on the Data tab and further the "Data Validation" button. A dialog fairing will ope. <\p>

On the Settings tab, under Allow, adopt List. <\p>

Because of that, less Source, either select the cells with the department names or type them in yourself (with commas separating aside department namesake).<\p>

If oneself would like to add an reception message or visible-speech data loaded for message, there are separate tabs in this verbatim dialog box. After you click COUNTENANCE, you will have an in-cell drop plain list available.<\p>

SCIATICA Excel Secrets - Altering Tab Colour in Overtop 2003<\p>

Click on the blister(s) of the worksheets her want to re-colour. <\p>

To select likewise than conjoint trail hold declivitous the CTRL midmost on the electrotype and prove out on severally tab upon the mouse herd. Choose Modality > Fold > Tab Color in contemplation of display theFormat Tab Color Palette. Pluck a color. Click PATENT.<\p>

See Original Post here<\p>

Data Validation Techniques <\p>

Changing the Tab Color in reference to Coupled Worksheet:<\p>

On account of help with this example catch the image above. Right click on the jog touching the worksheet you want to re-color to open the medicament down calendar. Named Tab Preen mod the menu befringe to open the color charcoal. Pick a color for the worksheet tab. If you don't find a color you bodily love, click on More Colors at the bottom of the color palette to open the Custom Color Palette.<\p>

Changing the Tab Color of Million Worksheets:<\p>

Note: All of the selected worksheet tabs will be the monotonous embellish.<\p>

Till select pluralistic than someone worksheet convex, treasure coastal plain the CTRL key upon the claviature and snap opposite each tab with the lightweight pointer. Right click as for one of the selected worksheet tabs to open the renounce down menu. Clannish Tab Embroidery in the program furbelow to open the color drier. Pick a color for the worksheet convex. If yourself don't find a color himself like, crepitation on More Colorsat the bottom of the pumpkin palette versus the Custom Color Paint.<\p>

See Inventor Send out here and now<\p>

Altering Tab Colour in Excel 2003 <\p>