On Macs without an End key, use Fn + Control + right arrow.Įxcel also contains powerful tools and shortcuts for selecting special groups of cells, including ways to select all formulas, all contacts, all text, blank cells, and so on. To get to the last cell on a worksheet, which is at the intersection of the last column and the last row, use Control + End. Select the cell in the upper-left corner of the table (not the. To select the first cell in a worksheet, use Control + Home on Windows, and Fn + Control + left arrow on a Mac. ColumnTitle as one word, without a space. These shortcuts work also when multiple cells are selected as. With any selection, shift + space will select an entire row, and control + space will select an entire column. Using this shortcut again will select the entire worksheet. When you're in a group of cells with data, you can select the entire set of data using Control + A on Windows, Command + A on a Mac. To get out of this mode, just press the Escape key or perform an action. This lets you make multiple selections without holding down a key.
#Add cell dropdown in 2011 word for mac mac#
This is handy when you want to format a group of non-adjacent cells, all at once.Īs an alternative to control-clicking, you can lock the "extend selection mode" using Shift + F8 on Windows, Fn Shift F8 on the Mac Drop-down enabled Lets the user open the combo box and make selections. Select an item and use the up or down arrows to change the order, Press -to remove a selected item.
Items in drop-down list Shows your current list.
Press + or Enter to add an item to the list. These selections do not need to be next to one another. Drop-down item Type in strings for the list box items. In this video, we'll cover some really useful shortcuts for selecting cells.įirst, as you know, you can click any cell in a worksheet to select it, and, of course, you can click and drag to select multiple cells.īy adding the Control key in windows, or the Command key on a Mac, you can make more than one selection.
0 kommentar(er)
