Data Validation | Spreadsheet Wise

Sep 15, 20233 min read

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.

Jan 19, 20233 min read

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

Dec 28, 20224 min read

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.

Aug 18, 20224 min read

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.

Aug 15, 20223 min read

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?

Jul 17, 20223 min read

How To Return Multiple Columns with VLOOKUP and Data Validation

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