Google Sheets Data Validation: How to Show Help Text

Yes. In Google Sheets in a web browser, select the validated cell or range, open Data > Data validation, expand Advanced options, enable Show help text for a selected cell, enter your message, and click Done. The message gives people guidance when they select a cell; it is separate from the warning or rejection that appears when they enter a value that does not meet the rule.

What data validation help text does

Data validation controls what can be entered in a cell. Depending on the rule, it can require a choice from a dropdown, a date within a range, a number that meets a condition, or text that follows a requirement. Help text adds an explanation to that rule so a person entering data knows what to do before making a mistake.

For example, a cell might accept a dropdown choice for a project status. A useful help message could say, “Choose the current status. Select Blocked only when work cannot continue without another person or decision.” The dropdown supplies the permitted choices; the message explains how to interpret them. This is especially helpful when a label is not self-explanatory or when the sheet is shared with people who did not create it.

The message is associated with the validation rule, not a permanent note typed into the cell. When a user selects a cell covered by the rule, Sheets can show the guidance. It does not fill in a value, change the list of allowed entries, or force someone to read the message.

How to add help text to a validation rule

In the browser version of Google Sheets, use these steps:

Select the cell or range where people will enter data. If you are creating a new rule, choose the complete intended range rather than only the first cell.
Open Data > Data validation. The data validation rules panel opens. If there is no rule yet, choose Add rule.
Check the rule’s apply-to range and choose the appropriate criterion, such as a dropdown or a date requirement. Set the allowed values or conditions.
Expand Advanced options in the rule editor.
Turn on Show help text for a selected cell, then type a concise instruction in the text field that appears.
Review the invalid-data behavior if needed, then click Done to save the rule.

To confirm it works, click a cell covered by the rule. The help message should appear as guidance associated with that selected cell. If it does not, reopen the rule and check that the help-text option is enabled and that the cell is actually included in the rule’s range. A rule set for B2:B20 will not guide someone entering data in B21.

Write guidance that helps people choose correctly

Good help text answers a practical question: what should the person enter, and what does the requirement mean? Keep the instruction near the field, use familiar language, and describe any convention that is not obvious from the cell heading or dropdown choices. “Enter the date the request was received, not the date it was approved” is more useful than “Enter a date.”

Useful messages often include one or more of these details:

The expected kind of value, such as a date, whole number, or selection.
The relevant boundary or format, such as “Use the month-end date” or “Enter a percentage from 0 to 100.”
A definition for an unfamiliar choice, such as what “On hold” means in a workflow.
A short example when the format could be misunderstood, such as “Use an email address like name@example.com.”
Where to ask for help if the right choice is not available.

Avoid repeating the entire list of dropdown options in the message when the dropdown already displays them. Also avoid treating help text as a substitute for a clear column heading. A heading such as “Approval status” and a message defining the choices work better together than a vague heading such as “Status” alone.

Help text, invalid-input warnings, and rejection

These controls serve different purposes. Help text is preventive guidance shown when someone selects a cell. The invalid-data setting determines what happens after someone tries to enter a value that does not satisfy the rule. Depending on the rule, Sheets offers a choice to show a warning or reject the input.

Help text: explains what to enter before or while the cell is being used.
Show a warning: allows an invalid value but flags it so the user can review the entry.
Reject input: prevents a value that fails the validation rule from being accepted.

For a required category such as an expense type, rejecting unlisted entries may keep a report consistent. For a field where unusual values are possible but should be reviewed, a warning may be more appropriate. Neither setting guarantees that every cell will contain a value: validation generally governs entries, and blanks may still be possible depending on the rule and workflow. If completeness matters, make that expectation clear and check the sheet for missing entries separately.

A frequent misconception is that turning on help text makes a field mandatory or automatically explains an error. It does neither. To control invalid entries, configure the validation rule’s invalid-data behavior. To tell users what to do, enable the help message. A carefully designed sheet may use both.

Apply, edit, and remove the message

A validation rule can cover one cell or a range. When the same rule applies across a range, its help text is part of that rule, so users covered by it receive the same guidance. If different rows need different instructions, consider separate rules for the relevant ranges rather than trying to make one message serve several unrelated purposes.

To revise the message, select a cell within the rule’s range and open Data > Data validation. Select the relevant rule in the panel, expand Advanced options, edit the help text, and save the change with Done. To stop showing it while keeping the validation, turn off the help-text option and save. To remove the validation itself, use the rule panel’s remove control; that also removes the rule’s restrictions, so check the selected range before doing so.

If you copy and paste cells, pay attention to whether the validation rule is copied along with the cell content or formatting. A pasted cell may bring its own validation settings, and that can replace the rule you expected on the destination. After filling a range or moving data, inspect the destination cells’ rules if the guidance or allowed choices unexpectedly change.

Common problems and practical checks

If no help message appears, first verify the cell address against the rule’s apply-to range. Next, open the rule and make sure the help-text option is enabled and the message was saved. If a cell has multiple rules or has been copied from elsewhere, inspect the rules listed for that area rather than assuming the visible dropdown proves the correct help text is attached.

Keep in mind that help text is contextual, not a sheet-wide announcement. A person may not notice it if they do not select the cell, and it is not a replacement for instructions in a heading, a short note near the table, or a separate guidance sheet. For a multi-step process, put essential instructions where they can be found without requiring people to discover a particular cell.

Also check the sheet as a user would: select a cell, read the message, open the dropdown if applicable, and try an invalid value if the rule is meant to block or flag one. Be careful during the test not to overwrite real data. A simple test copy of the sheet can help you verify the experience without disturbing the working version.

How it compares with notes and comments

Notes and comments can both provide information in a spreadsheet, but they are not identical to validation help text. A note is attached to a cell as general explanatory content. A comment is designed for discussion and collaboration, including replies. Neither one changes which values a cell accepts. Validation help text, by contrast, is connected to a data-entry rule and is a natural place for instructions specific to that rule.

Choose help text when the instruction explains how to complete a validated field. Use a note for supporting context that should remain attached to a cell but is not part of the validation behavior. Use a comment when collaborators need to discuss or resolve something. If information is crucial to everyone, put it in a clearly visible heading or instruction area as well; no cell-level message is guaranteed to be seen.

Sharing and accessibility considerations

People who can edit the sheet can encounter validation guidance while entering data, but the message should not be the only way to understand a critical process. Keep the language short and direct, avoid unexplained abbreviations, and do not rely on color alone to convey whether a choice is valid. A label such as “Needs review” is clearer than using only a red fill without an explanation.

Google Sheets also has mobile apps, but menus and the interaction with a selected cell can differ from the web browser. The steps above describe Sheets in a browser, where the full data validation rules panel is available. If someone enters data on a phone or tablet, verify that the workflow is understandable in that app and provide an additional visible instruction when the message alone is not sufficient.

When sharing a sheet, distinguish between people who can edit values and people who can change the validation rules. Protecting ranges can help prevent accidental edits to formulas, headings, or setup cells, but protection is a separate feature from help text and validation. Give collaborators only the access they need, and do not treat a validation rule as a security boundary or a guarantee that data is complete or correct.

Frequently Asked Questions

Can Google Sheets show a message when someone selects a cell?
Yes. Add or edit a validation rule, expand Advanced options, and enable Show help text for a selected cell. Enter the guidance and save the rule.

Does help text appear when a user enters an invalid value?
Help text is guidance associated with selecting the cell. To flag or block invalid input, set the rule to show a warning or reject the input. These are separate options and can be used alongside help text.

Can I show help text without a dropdown?
Yes. Help text is an option within data validation rules; it is not limited to dropdowns. It can explain other criteria too, such as a date or number requirement, as long as the cell has a validation rule.

Can different cells have different help messages?
Yes. Create separate validation rules for the ranges that need different instructions. If one rule covers a whole range, its guidance applies to the cells covered by that rule.

Is validation help text the same as a cell note?
No. Help text belongs to a validation rule and explains the entry requirement. A note is general information attached to a cell, while a comment supports discussion; neither one enforces allowed values.

Where is the help-text setting in Google Sheets?
Open Data > Data validation, select or add a rule, and expand Advanced options. The setting is labeled Show help text for a selected cell.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.