Windows 10: Data validation for multiple cells Excel

Discus and support Data validation for multiple cells Excel in Windows 10 Software and Apps to solve the problem; Hello Just wondering if there is a way to assign multiple cells with the same data validation formula on Excel as currently I have this formula that is... Discussion in 'Windows 10 Software and Apps' started by Azza R, Mar 3, 2025.

  1. AZZA R
    Azza R Win User

    Data validation for multiple cells Excel


    Hello Just wondering if there is a way to assign multiple cells with the same data validation formula on Excel as currently I have this formula that is set up for one cell =ORISNUMBERCell,cell=‘’ASAP”Which means people can only enter the date as DD/MM/YYYY or as ASAPCell is obviously referencing the exact cell I have the data validation formula setup for however I am wanting to apply this to multiple cells but don’t want to have to individually change the cell reference for each cell or having to delete the data in the cells as there is currently over 3000 cells in the excel sheet

    :)
     
    Azza R, Mar 3, 2025
    #1
Thema:

Data validation for multiple cells Excel

Loading...

  1. Data validation for multiple cells Excel - Similar Threads - Data validation multiple

  2. Data validation for multiple cells Excel

    in Windows 10 Gaming
    Data validation for multiple cells Excel: Hello Just wondering if there is a way to assign multiple cells with the same data validation formula on Excel as currently I have this formula that is set up for one cell =ORISNUMBERCell,cell=‘’ASAP”Which means people can only enter the date as DD/MM/YYYY or as ASAPCell is...

  3. Data validation for multiple cells

    in Windows 10 Gaming
    Data validation for multiple cells: Hello Just wondering if there is a way to assign multiple cells with the same data validation formula as currently I have this formula that is set up for one cell =ORISNUMBERCell,cell=‘’ASAP”Which means people can only enter the date as DD/MM/YYYY or as ASAPCell is obviously...

  4. Data validation for multiple cells

    in Windows 10 Software and Apps
    Data validation for multiple cells: Hello Just wondering if there is a way to assign multiple cells with the same data validation formula as currently I have this formula that is set up for one cell =ORISNUMBERCell,cell=‘’ASAP”Which means people can only enter the date as DD/MM/YYYY or as ASAPCell is obviously...

  5. Number problem in Excel cell

    in Windows 10 Software and Apps
    Number problem in Excel cell: When, I enter a number in one cell,then I enter into another cell.On that time the first cell number become into decimal.example likeex.in Frist cell I enter 25 then I changed cell second one,but the first one became 0.25 like this ,what can I do now ,i think any settings...

  6. Excel spreadsheet average of cells containing multiple variables

    in Windows 10 Network and Sharing
    Excel spreadsheet average of cells containing multiple variables: I keep a spreadsheet of blood pressure readings which I give to my GP to enable him to see a better picture of my condition.The format is 119/79/75 125/84/69 107/69/73 114/74/75 135/91/73 126/81/85 128/76/78 137/82/63 124/79/69etc on a daily basis..My GP asked if it would be...

  7. Excel spreadsheet average of cells containing multiple variables

    in Windows 10 Gaming
    Excel spreadsheet average of cells containing multiple variables: I keep a spreadsheet of blood pressure readings which I give to my GP to enable him to see a better picture of my condition.The format is 119/79/75 125/84/69 107/69/73 114/74/75 135/91/73 126/81/85 128/76/78 137/82/63 124/79/69etc on a daily basis..My GP asked if it would be...

  8. Excel spreadsheet average of cells containing multiple variables

    in Windows 10 Software and Apps
    Excel spreadsheet average of cells containing multiple variables: I keep a spreadsheet of blood pressure readings which I give to my GP to enable him to see a better picture of my condition.The format is 119/79/75 125/84/69 107/69/73 114/74/75 135/91/73 126/81/85 128/76/78 137/82/63 124/79/69etc on a daily basis..My GP asked if it would be...

  9. Cell formulas in excel spreadsheets

    in Windows 10 Customization
    Cell formulas in excel spreadsheets: Can someone help me to I presume clear formatting in cells. I'm entering a column of numbers in this case planting space guides for vegetables and every once in awhile a random cell will revert to a date. For example, if you look down the column you see 15-30, 40-50, Oct-15...

  10. coping text from a excel cell to another excel cell

    in Windows 10 Network and Sharing
    coping text from a excel cell to another excel cell: I am trying to copy text from one excel to another excel cell automatically on the same worksheet https://answers.microsoft.com/en-us/windows/forum/all/coping-text-from-a-excel-cell-to-another-excel/5a272c74-33e6-457c-82f8-3ae3196e8f81"