#Mac excel shortcut for dropdown full#
#Mac excel shortcut for dropdown series#
#Mac excel shortcut for dropdown mac#

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?

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. From there, I can use Command C for comments, Command O for Constants, Command F for formulas and so on.Īt the time of this recording, in early 2016, this feature doesn't appear to work in the current version of Office 2016.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. One last note if you are using Excel 2011.Īlthough it's not evident, you can often select controls in a dialog using the Commend key and a letter.įor example, if I use Control + G for Go To, I can use Command + S to access Go To Special. It's possible to tab to Cancel button, and then use the spacebar to push the button.īut, if you just want to cancel the dialog, it's easiest to press the Escape key. In this case OK is the default, which means that pressing return will accept settings and dismiss the dialog.

Note that Mac dialog boxes have a default button selected. To confirm a selection, press either Enter or the spacebar.Īfter you select a checkbox, you can toggle it on or off with the spacebar. Notice that each control is highlighted when active.įor lists that are already open (for example, fonts in this case) use the up and down arrow keys to make a selection.įor dropdown controls, like Underline, use the spacebar to open, and arrow keys to navigate options. To step through all available controls, use the Tab key. To reverse direction and go left, just add the shift key. In Mac 2011, to switch tabs, you can use Control + tab to move right. To illustrate, let's look at the Format Cells dialog, which provides many options in a tabbed interface.įirst, notice this dialog has an active Tab, which is remembered from the last time you accessed the dialog. This will let you tab and shift tab to select all dialog box controls.

Then make sure 'All controls' is selected in the Full Keyboard Access area. Go to System Preferences > then Keyboard > and to the shortcuts tab. On a Mac, you have a more limited ability to select controls in dialog boxes, but it is possible to drive these dialogs entirely from the keyboard.įirst, to allow you to access all dialog controls, you need to enable a preference. Some examples include Format Cells, find and replace, spelling, paste special, go to special, and many more. In this video, we'll look at shortcuts for navigating dialog boxes on a Mac.Įxcel has a large number dialog boxes that you will use frequently.

#Mac excel shortcut for dropdown series#

#Mac excel shortcut for dropdown mac#

#Mac excel shortcut for dropdown full#