The quickest way to show **all** the formulas on a Google Sheet is to use the shortcut `Ctrl`+`'` (`⌘`+`'` on Mac). This will make every cell in your sheet display its formula instead of the result. Hit the same keyboard shortcut again to toggle the view back to the standard display.

To view the formula in a single cell, you need to click on the cell and ensure the formula bar is visible or put the cell into edit mode by selecting it and hitting the `Enter` (`↵`) key or **double-clicking** on it.

So that’s it! That was quick… Showing formulas is easy, but are you interested in learning how best to hide a formula in a google sheet?

If not, I’ll go over where to find these options on the menu and how to extract a formula from a cell for display.

## Show all formulas

This is very useful when trying to understand how a sheet works, especially if you want to look at the formulas in more than once cell at a time.

The keyboard shortcut for show all formulas is `Ctrl`+`'` (`⌘`+`'` on Mac), but it is also available on the menu under **View > Show > Formulae**.

Here’s a video showing the effects of `Ctrl`+`'` on a sheet displayed on ChromeOS.

## Show or hide the formula bar

When you click on any sheet cell, the formula bar should show the formula for that cell. The formula bar is located just below the toolbar.

It is possible to **hide** the formula bar, so if you can’t see it, make sure you haven’t accidentally toggled it to be hidden from the menu options (**View > Show > Formula bar**).

Don’t think that hiding the formula bar will keep your cell formula from prying eyes. If you really want to do that, you need to read up on the 2 best methods we’ve found to hide formulas from your sheet viewers.

## Show the formula for a single cell

If you put a cell into edit mode, it will display its formula and the formula result. To put a cell into edit more you either need to **double click** on it or select it and hit `Enter` (`↵`).

You can see the cell below has the formula `=1+2+3+4+5`

and displays the formula and the result (15) floats above it.

## Extract and display the formula from a cell

If you want to show the formula next to the results on a cell without putting the cell into edit mode, you will need to extract it and display it in an adjacent cell. To make the contents of a cell display as text you need to add a single quote to the start.

This is very easy. Here’s how to extract a formula for display:

- Select the cell you want to extract the formula from by clicking on it.
- From the menu, use
**Edit > Copy**, or the shortcut`Ctrl`+`c`(`⌘`+`c`on Mac). - Select an adjacent cell to display the formula.
- From the menu, use
**Edit > Paste**, or the shortcut`Ctrl`+`v`(`⌘`+`v`on Mac). - Edit the copy of the formula in the formula bar, or by double clicking the cell
- Add a single quote to the start (
`'`)