Why is the formula bar of data validation function in Excel's data validation menu so short?

欣 袁 21 Reputation points

For example, if "custom" is selected in the "validation conditions"; of the "data validation" function of Excel, the formula bar below is particularly short. Can the software developer make the visual length or width of its modification larger. When using the array displacement function, this formula column is not suitable for writing long formula at all.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
26,906 questions
0 comments No comments
{count} votes

Accepted answer
  1. Leon Laude 85,216 Reputation points


    Q&A currently supports the products listed over here https://learn.microsoft.com/en-us/answers/products (more to be added later on).

    You can reach the experts in the dedicated Microsoft Excel forums over here:


    (Please don't forget to accept helpful replies as answer)

    Best regards,

0 additional answers

Sort by: Most helpful