question

83332372 avatar image
0 Votes"
83332372 asked ·

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

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-supported
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

LeonLaude avatar image
0 Votes"
LeonLaude answered ·

Hi,

Q&A currently supports the products listed over here https://docs.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:
https://social.technet.microsoft.com/Forums/office/en-US/home?forum=excel

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel

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

Best regards,
Leon


· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you!!

0 Votes 0 ·