Excel's input messages: a cleaner alternative to cluttered notes and comments
By
Tony Phillips
Summary
This article discusses how Excel's "input messages" feature (part of Data Validation) offers a cleaner, less cluttered alternative to traditional cell notes and comments. While most users rely on notes or comments to add guidance to spreadsheets, these create visible indicators (red triangles, badges) that can clutter the interface. Input messages, by contrast, appear as tooltips only when a cell is selected, keeping the spreadsheet visually clean. The article explains how to set up input messages, compares them to notes and comments, and argues they are an underutilized tool for better spreadsheet design and user guidance.
Source
Key quotes
· 3 pulledUnlike notes, Excel's input messages stay hidden until needed, offering cleaner cell-level guidance without overlapping pop-ups.
Most users overlook this feature, but it's one of the neatest ways to keep your spreadsheets tidy while still providing helpful context.
Input messages appear as tooltips only when a cell is selected, keeping the spreadsheet visually clean.
You might also wanna read

How to Design Form Error Messages That Help Instead of Punish Users
This article examines how form error messages in user interfaces often feel punitive rather than helpful. It argues that common practices —
ChatGPT for Excel: AI-Powered Spreadsheet Creation and Analysis Tool
ChatGPT for Excel is an AI-powered tool that enables users to build and update Excel spreadsheets using natural language commands. It can cr
Survey Examines How Large Language Models Are Transforming Spreadsheet Intelligence
This article presents a survey on the integration of Large Language Models (LLMs) into spreadsheet environments. It highlights that spreadsh
Cell: A terminal spreadsheet editor with Vim keybindings, written in Rust
A terminal-based spreadsheet editor called "cell" that combines spreadsheet functionality with Vim keybindings. Written in Rust, it supports
QuickSheet: A Free Menu Bar Spreadsheet App for Mac with Real Formulas and Excel Compatibility
QuickSheet is a free, lightweight spreadsheet app that lives in your Mac's menu bar, allowing instant creation and editing of spreadsheets w
Critique of Excessive Icon Usage in Menu Design
The article critiques the design trend of placing icons next to every menu item by default, using Google Sheets as a primary example. The au

Comments
Sign in to join the conversation.
No comments yet. Be the first.