Chat with us, powered by LiveChat

Insert Functions

How to Insert Functions in Google Sheets

Insert Functions

There are hundreds of functions available for you to perform just about any kind of calculation. Functions are sorted into categories that you can browse.

Insert a Function

  1. Click in the cell where you want to add a function.
  2. Click Insert on the menu bar.
  3. Select Function.
  4. Select a category.
  5. Select a function.
    How to Insert a Function in Google Sheets.
  6. Most functions require some kind of input or data to calculate, called arguments.

  7. Enter the function's arguments.
    How to Insert a Function in Google Sheets.
  8. Press Enter.

The function is applied to the selected cell.

Get Help on Functions

If you're not sure what category a certain function is found in, you can consult the Google Sheets function list page to find out.

  1. Click Insert on the menu bar.
  2. Select Function.
  3. Select Learn more.
    How to get help on Functions in Google Sheets.
  4. A new browser tab opens to the function list. You can scroll through this list to see all of the available functions, their syntax, and a description of what they do.

  5. Enter keywords in the search field.
    How to get help on Functions in Google Sheets.

Sheets displays information about the topic you entered.

FREE Quick Reference

Click to Download