Accountancy Part CSpreadsheet

What is the maximum number of columns that a data validation form in…

What is the maximum number of columns that a data validation form in Excel can display?

Answer & explanation

Correct answer: option 3

The correct answer is Option (3) → 32

A data form in Excel shows one record at a time in a dialog box, with each column heading as a label and a text box beside it. The built-in form can handle up to 32 columns; a list wider than that cannot be shown in one data form.

NCERT (2026-27 edition):
Data Validation Form – “… The data form displays all column headers as labels in a single dialog box. Each label has an adjacent blank text box in which we can enter data for each column, up to a maximum of 32 columns.”