You are here: Home / Archives for April 2008

How to validate a cell value

April 8, 2008 By

If you are designing an excel sheet for other users to enter data, or even for your own use, it is a good idea to use the data validation feature to insure that only correct data will be entered. hear is how you do it:

  1. Select the cell you want to validate.
  2. On the Data menu, click Validation, the Data Validation dialogue box will be shown.

  1. Click the Settings tab.
  2. Specify the type of validation you want. Suppose you have a numeric value and you want to allow only values between 1 and 99, then:
    1. In the Allow combo box select ‘Decimal’.
    2. In the Data combo box select ‘Between’.
    3. In the Minimum edit box enter ‘1’.
    4. In the Maximum edit box enter ‘99’.

To show an error message when an invalid data is entered:

  1. Click the Error Alert tab.
  2. Fill the Title and Error Message edit boxes with appropriate text. (See example).

To remove data validation, click the Clear All button in the Settings tab.

Applies to : Excel 2003

Filed Under: Data, Validation Tagged With: , , ,

How to link to values in another worksheet / workbook

April 5, 2008 By

    If you want data from one worksheet to be linked to, or shown in another worksheet then follow these steps:

    1. In the sheet you want to link to (source) select the cell where the value is.
    2. Right click and select Copy.
    3. In your main sheet (target), select the cell where the value is to be displayed.
    4. Right click and select Paste Special.
    5. When the dialog box appear click on the Paste Link button.
    6. The value in the source sheet will now be reflected in the target sheet.
    7. Every time the source sheet is updated, the target sheet will also be updated with the new values.
    8. The same procedure can be applied to link to data in another workbook.

    Applies to : Excel 2003

    Filed Under: Data, Links Tagged With: , , ,

    How to create a custom list to use in Autofill

    April 2, 2008 By
    1. In Excel menu click Tools.
    2. In the Tools menu click Options.
    3. Click the Custom Lists tab.
    4. Click the Add button. The cursor will move the List entries edit box.
    5. Enter the data for your list separated by commas. E.g. East, West, North, South.

     

    Now if you enter “East” in any cell and drag the fill handle, other cells will automatically be filled with West, North … etc.

    Applies to: Excel 2003

     

    Filed Under: Data, Lists Tagged With: , , , ,
    Newer Posts »