If you want to protect the cell (s) as well, ensure Locked is checked. Right-click the selected cell (s) and choose Format Cells or press Ctrl + 1. Give them a try the next time you're working with formulas in Excel on a Mac. The first step is to hide the formulas: Select the cells with the formulas you wish to hide.
That's all there is to it! These shortcut keys will save you a lot of time and frustration when working with formulas in Excel. So, if the worksheet contains formulas in any cells, pressing Command + Option + ' will display those formulas in all cells. This shortcut key will toggle the display of formulas for all cells in the worksheet. So, if you have a range of cells selected that contains formulas, pressing Command + Shift + ' will display those formulas in the cells.įinally, what if you want to show formulas for all cells in a worksheet? That's the easiest of all! Just press Command + Option + ' (apostrophe). This shortcut key will toggle the display of formulas for the entire selection of cells. Now, what if you want to show formulas for an entire selection of cells? That's easy too! Just press Command + Shift + ' (apostrophe). Now in that document, place the cursor where you want to insert the formula for getting result easily. So, if the cell currently contains the formula =A1+B1, pressing Command + ' will display that formula in the cell. Step 2: Place the cursor in the cell where you need to see result. To display all formulas, in all cells, press CTRL + (you can find this key above the tab key). When you select a cell, Excel shows the formula of the cell in the formula bar. To show the formulas instead of their results, press CTRL + (you can find this key above the tab key). This shortcut key will toggle the display of the formula for the current cell. By default, Excel shows the results of formulas. To start, let's take a look at the shortcut key to show formulas in Excel for the current cell. There's got to be a better way, right? Well, there is! Here are the best shortcut keys to show formulas in Excel on a Mac.
If you work with formulas in Excel, you know that it can be frustrating to have to constantly click the little button in the top left corner of the cell to show the formula.