When you create worksheets that will be used by others, it’s important to make sure they can only enter valid data. Use Excel’s data validation features to make rules to restrict the type of data or values that others can enter into a cell. Learn more at the Office 365 Training Center:
- Category
- Software
Sign in or sign up to post comments.
Be the first to comment
Up Next
-
Create formulas in Excel 2016
by lily 174 Views -
Analyzing Salesforce Data with Excel
by lily 200 Views -
Visio Data Visualizer: Automatically create process diagrams from Excel data’
by lily 343 Views -
Python in Excel: a powerful combination for data analysis and visualization
by ava 55 Views -
How to apply data validation to cells in Microsoft Excel
by ava 106 Views -
DevBytes: Efficient Data Transfers - Understanding the Cell Radio
by lily 817 Views -
Name cells and ranges in Excel 2016
by lily 147 Views -
Create data-driven diagrams with Microsoft Excel and Visio
by ava 150 Views -
Create data-driven diagrams with Microsoft Excel and Microsoft Visio
by ava 151 Views -
Python in Excel: Dive into data
by ava 66 Views -
Understanding the Excel Data Model (Office 15-Minute Webinar)
by lily 250 Views -
Prototype and Validate
by lily 129 Views -
Microsoft 365 Copilot in Excel | Analyzing Data
by ava 22 Views -
Why use Data Validation in Excel?
by lily 195 Views -
Inside Excel - Episode 1: Insert Data with Picture
by Jeva 146 Views -
How to filter data in a range or table in Microsoft Excel
by ava 142 Views -
Copy cell formatting in Microsoft Excel
by Jeva 154 Views -
Inside Excel - Episode 2: Rich Data Types
by Jeva 166 Views -
Trailer: Understanding the Excel Data Model
by lily 249 Views -
Using Conditional Formatting in Excel to make data pop #shorts #microsoft #excel
by ava 96 Views -
Microsoft's finance team leverages Copilot in Excel for data analysis
by ava 32 Views -
How to get more new data types in Microsoft Excel
by ava 163 Views
Add to playlist
Sorry, only registred users can create playlists.