restrict data

  1. L

    Restricting Paste on multiple columns with different Data Validations

    Hi everyone. I have a worksheet that includes roughly 20/25 different columns. Five of those columns contain Data Validation drop-downs to different data lists. I'm having an issue with users of this worksheet copy/pasting incorrect data over the top of the columns with Data Validation vs...
    • LostinVA
    • Thread
    • columns data data validation (list) restrict data validation
    • Replies: 8
    • Forum: Excel Questions
  2. A

    Restrict entering duplicate data in multiple column

    I want to restrict entering duplicate data in multiple column. <tbody> B C D F 20 Client Name Year Quarter Form Type 21 ABC 2017-18 Q1 26Q 22 XYZ 2017-18 Q1 26Q 23 ABC 2017-18 Q1 24Q 24 ABC 2017-18 Q1 26Q </tbody> From the above table we can see that Row no’s 21, 22 & 23 are...
  3. E

    Restrict range in input box

    I have an input box that requires user input of a cell range. The columns are always the same eg. D:H. These columns cannot be varied. The row numbers do vary. Can anyone please tell me how to restrict entry to (for example) D50:H80 or D150:H250. Thanks in advance,
    • elm
    • Thread
    • column range input box restrict data
    • Replies: 4
    • Forum: Excel Questions
  4. R

    Restrict Table Field to Specific Text Values

    I use Access 2010. Is there a way to restrict a table's field to specific field values. Let's say I have a table called "Fruits" with the field "Type". I want the user to only be able to specify one of these values for the "Type" field: apple banana grapes kiwi pear Is there a way to restrict...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top