How To Mimic Radio Buttons With Formulas and Checkboxes

In this post, we’ll look at how to mimic radio buttons with formulas and checkboxes in Google Sheets.

Radio button behavior with checkboxes and formulas

This formula method has one limitation: you have to uncheck the current selection before you can check a different one.

With true radio buttons, when you click any button it will unselect the other one for you. You don’t have to do the extra step of manually unselecting it first.

For that reason, I recommend using an Apps Script method to create true radio buttons in Google Sheets.

However, the formula method presented in this post is useful if you don’t have access to Apps Script or simply don’t want to add code to your project.

Continue reading How To Mimic Radio Buttons With Formulas and Checkboxes

How To Create A Select All Checkbox in Google Sheets

In this post, you’ll learn how to create a Select All checkbox in Google Sheets, as shown in this image:

select All Checkbox in Google Sheets

But before we look at that, did you know there’s already a quick way of selecting all checkboxes manually?

Continue reading How To Create A Select All Checkbox in Google Sheets

How To Use The RANDBETWEEN Function In Google Sheets

The RANDBETWEEN function in Google Sheets is used to generate a random integer (whole number) between two values.

For example, this RANDBETWEEN formula generates a random number between 1 and 10:

=RANDBETWEEN(1,10)

RANDBETWEEN Function In Google Sheets

The function will generate a new random number each time your Sheet changes.

Continue reading How To Use The RANDBETWEEN Function In Google Sheets

How To Create A Random Number Generator In Google Sheets

The RAND function in Google Sheets generates a random number between 0 and 1 and can be used as a random number generator in Google Sheets.

Random Number Generator In Google Sheets

The RAND function outputs a decimal number between 0 and 1, for example, 0.2760773217.

Continue reading How To Create A Random Number Generator In Google Sheets

How To Wrap Text In Google Sheets

In this post, we’ll look at how to wrap text in Google Sheets so that long strings fit inside cells and can be read easily.

Method 1: Via Format Menu

Select a range of data and go to the menu: Format > Wrapping > Wrap

Wrap Text In Google Sheets Format Menu

Next to the wrap text option, you’ll find the clip option (show on one line and don’t allow any overflow) and overflow option (show on one line and allow to spill into adjacent cells).

Continue reading How To Wrap Text In Google Sheets