Please send us your comments on this article.
#EXCEL SHORTCUT KEYS DISPLAY FORMULA HOW TO#
To move the cursor from the selected cell to the formula bar by shortcut key. Formula bar shortcut Jump the cursor to the formula bar. Select the cell that contains the formula to check the referenced cell. Try using this method when you are creating or editing long formulas. Select cells that are directly referenced in a formula Press Ctrl + Shift + A to enter argument names in the formula. Formula shortcuts Insert argument names into formulaĬontrol + shift + A Select cells that are directly referenced in a formulaĬontrol + Insert argument names into formulaĭisplays the name of the function argument in the cell.Įnter a function name in any cell. In this article, I’ll show you how to use shortcut keys to display formula arguments and how to use shortcut keys to select reference cells. After that, just press the keyboard shortcut keys Ctrl + and you will get all the formulas displayed instead of. You can also use shortcut keys to copy formulas to other cells or replace formulas with values, so if you remember the shortcut keys, you can work with just the keyboard. Written in Excel for Microsoft 365 version 2202Įxcel has various shortcut keys for formulas.Give them a try the next time you're working with formulas in Excel on a Mac.Formula shortcuts in Excel - Excel Hack Formula shortcuts in Excel 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. Ctrl + arrow keys: move to the top, bottom, left edge, right. Ctrl + Pg Dn (PageDown): The shortcut switches Sheet to sheet right on the open sheet Ctrl + Pg Up (PageUp): Switch to the sheet to the left of the open sheet. Press Ctrl + to automatically select the referenced cell in the formula. Select cells that are directly referenced in a formula Select the cell that contains the formula to check the referenced cell. Ctrl + : Toggle Show formulas in cells instead of values. Press Ctrl + Shift + A to enter argument names in the formula. So, if the worksheet contains formulas in any cells, pressing Command + Option + ' will display those formulas in all cells. Ctrl + Shift + U: Switch to expand or collapse the formula bar. 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. Please note that the question mark button at the top right hand side of the Excel application is no. Now, what if you want to show formulas for an entire selection of cells? That's easy too! Just press Command + Shift + ' (apostrophe). We will understand the working of this function with some example. The most commonly used mathematical functions are SUM, SUBTOTAL, RANDBETWEEN, PRODUCT, SQRT etc. It will open a drop-down list of functions as per the below screenshot. So, if the cell currently contains the formula =A1+B1, pressing Command + ' will display that formula in the cell. Click on the Math & Trig functions category. This shortcut key will toggle the display of the formula for the current cell. Microsoft Excel Keyboard Shortcuts Display the insert function dialog box, Shift + F3 Copy the value from the cell above, Ctrl + Shift + Copy the formula. Note: as you can see, Excel highlights all cells that are referenced by a formula. To display all formulas, in all cells, press CTRL + (you can find this key above the tab key). To start, let's take a look at the shortcut key to show formulas in Excel for the current cell. When you select a cell, Excel shows the formula of the cell in the formula bar.
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.