The Data Validation function of Google Sheets

April 8, 2022

A free Office suite fully compatible with Microsoft Office

Free Download
Free download

Apart from WPS Office and Microsoft Office, Google Docs also can process documents in our daily work. Today, this article will introduce to you the Data Validation of Google Sheets. Are you ready to get it?

First of all, let me introduce to you what is Google Docs.

An introduction to Google Docs:

Google Docs is an online word processor that is part of a free, web-based suite of Google Docs Editors that also includes Google Sheets, Google Slides, Google Drawings, Google Forms, Google Sites, and Google Keep. Google Docs is accessible through an Internet browser as a web-based application, as well as as a mobile app on Android and iOS, and as Google's desktop app Chrome OPERATING SYSTEM.

Today, this article will focus on how to use Google Sheets. Now, let me introduce to you the Data Validation functions of Google Sheets

How to use the Data validation function

ü Open Google Docs and create a new sheet.

ü Select the cell or cells where you want to create a drop-down list.

ü Click Data, and choose Data validation.

In the Data validation pop-up dialog box, we can set the Cell range, Criteria, whether shows a drop-down list in cell or not, on invalid data and Appearance. You can make a dropdown, create a checklist and list in Google Sheets by setting these options.

Other components of Google Docs

Google Docs has Google Sheets in addition to this functional component, there are also Google Slides, Google Drawings, Google Forms, Google Sites, Google Keep.

What are the pros and cons of Google Docs?

Ø Pros:

ü The biggest highlight of Google docs is that it can be written by multiple people at the same time, which can realize real-time synchronization.

ü Google Docs can be saved in real-time and synced in the cloud. Don't worry about losing documents again.

ü Google Docs has a version history feature.

ü The comment function of Google Docs is interactive.

ü Google Docs is a free service.

Ø Cons:

First of all, the layout ability of Google Docs is still slightly weaker, if you need complex typography, it is better to use Microsoft Word. Second, because Google Docs is a web version, there is no client software, so it is not suitable for working with large files. If you have a 100MB Word document, imagine that the web page is loaded and synchronized in real-time, which requires good hardware and network environment.

This is today's introduction to Google Docs. If you want to know more about other office software, you can come to WPS Academy to know more.

Click the following free tutorials developed by WPS Academy:

A guide to download Microsoft Office for Mac

7 professional office software, come and download quickly

Was this helpful?