Data Validation | Spreadsheet Wise

How To Highlight Duplicate Rows in Google Sheets

Highlighting duplicate rows in Google Sheets can be really useful to draw attention to duplicate data quickly.

Dependent Drop-down Chips in Google Sheets

You can take drop-down lists to the next level by making them dynamic with dependent Drop-down Chips

Create a Dropdown list with Smart Chips in Google Sheets

Dropdown chips are a better-looking version of the old-fashioned dropdown lists you could create using Data Validation.

How to Create a Drop-down list in Google Sheets

Creating a drop-down list in Google Sheets is super easy to make with Data Validation and even easier to use. Find out how.

How to Bulk Translate with Google Sheets

With Google Translate, you can translate anything, but did you know that you you can also achieve this using a Google Sheets Function?

How To Return Multiple Columns with VLOOKUP and Data Validation

The VLOOKUP function is unquestionably in my top 5 most used functions.