Excel
Word
PowerPoint
Outlook
Google Sheets
Google Docs
Google Slides

Open Data Validation Dialog

Open the Data Validation dialog to set rules for cell input.

Keyboard shortcut by app

App Windows Mac
Microsoft 365
Excel
Alt+A+V+V
 Not available
Word Not available Not available
PowerPoint Not available Not available
Outlook Not available Not available
Teams Not available Not available
Google Workspace
Google Sheets Not available Not available
Google Docs Not available Not available
Google Slides Not available Not available
More in Data
AutoFit Column Width AutoFit Row Height Collapse Grouped Rows or Columns Delete Columns Delete Rows Expand Grouped Rows or Columns Group Rows or Columns Hide Columns Hide Rows Insert Columns Insert Rows Open Sort Dialog Sort Ascending Sort Descending Ungroup Rows or Columns Unhide Columns Unhide Rows

Popular Functions

Hand-picked function guides that work in both Excel and Google Sheets.

SUMIF Function in Excel & Google Sheets (Syntax + Examples) SUM Function in Excel & Google Sheets (Syntax + Examples + Fixes) FORECAST Function in Excel & Google Sheets FILTER Function in Excel & Google Sheets (Syntax + Examples + Fixes)