NEWSheetSteps AI now turns entire websites into clean spreadsheet columnsExplore web scraping →

Google Sheets tutorials›Spreadsheet basics›Create a button

Google Sheets · Verified tutorial

Create a button in Google Sheets

This is a safe button-design fixture. Enter exactly "Run report" in A2, "Refresh summary" in B2, and "A1:D20" in C2. Then make A2 bold. Do not create or run a script.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

This is a safe button-design fixture. Enter exactly "Run report" in A2, "Refresh summary" in B2, and "A1:D20" in C2. Then make A2 bold. Do not create or run a script.

Step-by-step

1

Select the targetThis is a safe button-design fixture.

2

Complete the next actionEnter exactly "Run report" in A2, "Refresh summary" in B2, and "A1:D20" in C2.

3

Apply the changeThen make A2 bold.

Shortcut or faster method

Select the target cell, type or paste the formula in the formula bar, then press Enter.

Expected result

The Run report button design is registered, its label is bold, and the existing Clear form design remains.

Common mistake

Applying the change to more rows, columns, or cells than the task specifies.

Troubleshooting

Re-select A2 and repeat the final action. The Run report button design is registered, its label is bold, and the existing Clear form design remains.

Example spreadsheet data

This is the clean fixture used for the verified run.

Button label	Assigned action	Target range

Clear form	Clear inputs	B2:B8

Video transcript

Open the prepared Button setup spreadsheet.
Select the target. This is a safe button-design fixture.
Complete the next action. Enter exactly "Run report" in A2, "Refresh summary" in B2, and "A1:D20" in C2.
Apply the change. Then make A2 bold.
The Run report button design is registered, its label is bold, and the existing Clear form design remains.