LOWER Google Sheets Function [With Quiz]

Kieran Dixon Updated:  August 24, 2021

In Google Sheets the LOWER function outputs the provided text with all lowercase characters.

LOWER Syntax

• text = the "text" or a cell reference to the text you want to convert to lowercase characters.

FREE RESOURCE

Google Sheets Cheat Sheet

12 exclusive tips to make user-friendly sheets from today:

Get The Cheat Sheet ➜

You'll get updates from me with an easy-to-find "unsubscribe" link.

LOWER Function Example

Using The LOWER Function On A Whole Column

By combining the LOWER function and the ArrayFormula function you can force LOWER to accept more than one argument.

This means you can make multiple cells lowercase, an entire column or row, or even a table with only one formula.

Here's an example using the same data as above:

All of the text is converted to lowercase characters using a single formula.

LOWER Errors

The LOWER function is very stable, handling the following without error:

• Blank cells,
• Numbers (returning them as text), and
• Boolean data (returning them as lowercase text)

If you input a range (e.g. A2:A4) without using ArrayFormula it will output one piece of lowercase text if the range crosses the same row or column as the formula's cell.

Otherwise, it will throw a #VALUE! error:

LOWER Function Quiz

Here's a quick summary of how to use the quiz spreadsheet:

1. Select the required cell while the formula bar is empty
2. Type your answer in the formula bar
3. You can click on the spreadsheet to add cell/range references

Complete all questions to solidify your understanding of the LOWER function.

FREE RESOURCE

Google Sheets Cheat Sheet

12 exclusive tips to make user-friendly sheets from today:

Get The Cheat Sheet ➜

You'll get updates from me with an easy-to-find "unsubscribe" link.

Kieran Dixon started using spreadsheets in 2010. He leveled-up his skills working for banks and running his own business. Now he makes Google Sheets and Apps Script more approachable for anyone looking to streamline their business and life.

You might like:

How To Capitalize The First Letter In Google Sheets

Learn step-by-step how to capitalize every word, the first word, or every sentence in a cell or column in Google Sheets.

Generate A Random Item From A List In Google Sheets

Want Google Sheets to give you a random item from a list? Here are the exact formulas to get single or multiple outputs with no repeats.

MAX Google Sheets Function [With Quiz]

The MAX function in Google Sheets finds the maximum! It doesn't matter how many numbers, MAX will quickly find the largest / most positive.