On Excel for macOS, the same control+A shortcut will bring up the more expansive Formula Builder sidebar, where you can build the formula and see all the definitions at once.
Keyboard shortcut for mac excel windows#
At that point, hitting Ctrl+A in Excel for Windows brings up a dialog box, Function Arguments, that will walk you through building the formula, providing a definition for each parameter in turn. Happily, you don't have to.Įxcel already provides a modicum of help, listing the parameters to a function when you type the opening parenthesis following its name. You don't have to learn all the answers, but it helps to learn where to find them.Īnd so it is with building formulas in Excel: There are so many functions, with so many parameters, that it's nigh-on impossible to remember them all. If there's one thing I learned at college, it's that there's no shame in looking it up. This is a little like clicking on the triangle at the top-left of the sheet, with the difference that it leaves the current cell selection unchanged, while clicking the triangle makes A1 the current cell. If any of the cells in the current selection are empty, then Ctrl+Shift+spacebar will select the entire sheet. If you have cells in several adjacent rows selected, Shift+spacebar selects the entirety of each of those rows, while Ctrl+spacebar will select the entirety of the columns in which you have adjacent cells selected.Ĭurious minds will want to know: What happens if you do both simultaneously? Hitting Ctrl+Shift+spacebar will extend the selection to form a rectangle encompassing all contiguous non-empty cells adjacent to the currently selection. Did you know you can extend the selection from one cell to an entire row by hitting Shift+spacebar? Or from one cell to an entire column by hitting Ctrl+spacebar? (This one is control+spacebar in macOS too, as Command+spacebar is the system-wide shortcut for Spotlight search.) Note that this trick also works the other way, for transposing a horizontal block of cells into a vertical one. As long as the source and destination areas don't overlap, you should see your cell entries spread across the sheet rather than down it.Įxcel will only let you perform this trick using Copy, not Cut, so to delete the data from its original position, click once again in the first cell of the column, hold Shift and double-click the lower border of the cell to extend the selection, then hit Ctrl+Delete (just delete in macOS) to empty the cells. Now, the magic: Call up the Paste Special dialog with Ctrl+Alt+V (or command+control+V in macOS) hit E to select the Transpose option, bottom right, then Enter. Copy the selection, then select the leftmost of the cells where you would like the transposed labels to appear. You can click and drag or, if the column is very long, try this trick: Select the first cell in the column, hold down the shift key, and double-click on the lower border of the selected cell: Excel will extend the selection downward until it encounters an empty cell. Start by selecting the column of labels or other data you want to transpose. Rather than cut and paste them one at a time to their correct position, why not flip the column of data through 90 degrees using the Paste Special/Transpose option?
Keyboard shortcut for mac excel series#
You distractedly type in a whole series of labels, then realize that you meant them to go across a row, and not down a column. You can also find this on the Formulas tab of the Ribbon.
It may be that someone has inadvertently replaced one of the formulas with a value they calculated by hand. This trick is particularly useful if you're auditing a shared spreadsheet, for example to see why some calculated cells in one column are not updating when you change the inputs in another.
If you have a lot of cells to check, that's going to take you a long while, but there is a way to see all the formulas in a worksheet at once: You can toggle the display between formulas and values by hitting Ctrl+` - that's a backtick, the symbol found to the left of the 1 key on U.S.
If you want to check your working, you can always click on a cell to see the formula behind the cell's value: It will be displayed in the formula bar, between the ribbon and the worksheet. The default display mode in Excel is to show you the results of formulas, so a column of sales figures ends in your total sales for the month, not a truncated formula beginning =SUM(D2.
0 kommentar(er)
