Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Data validation rules do not extend while adding new rows in a table.

While formulas in columns extend with new rows added to a table, data validation rules do not. That's unintuitive and very inconvenient.

2 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Andrey Minakov shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Andrey Minakov commented  ·   ·  Flag as inappropriate

        Bryon, thanks for your comment. Yes, I refer to "plain" tables (Insert->Table of the Ribbon). Please could you say what do you mean under "Data" table? Data table of What-If Analysis?

      • Bryon Smedley commented  ·   ·  Flag as inappropriate

        Data Validation works if the table has been "upgraded" to a Data Table. Are you referring to "plain" tables?

      Feedback and Knowledge Base