Hold down OPTION and drag the rows or columns to another location. Move or copy data between existing rows or columns. Hold down SHIFT and drag your row or column between existing rows or columns. Excel makes space for the new row or column.

This article is for people with visual impairments who use a screen reader program with the Office products and is part of the content set. For more general help, see. Many users find that using an external keyboard with keyboard shortcuts for Excel for Mac helps them work more efficiently.

For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen and are an essential alternative to using a mouse. This article itemizes the keyboard shortcuts for Excel for Mac. Many of the shortcuts that use the Ctrl key on a Windows keyboard also work with the Control key in Excel for Mac. However, not all do.

Note: Changing system function key preferences affects how the function keys work for your Mac, not just Excel. After changing this setting, you can still perform the special features printed on a function key. Just press the FN key. For example, to use the F12 key to change your volume, you would press FN+F12. If a function key doesn't work as you expect it to, press the FN key in addition to the function key. Activity app for mac. If you don't want to press the FN key each time, you can change your Apple system preferences: Change function key preferences with the mouse • On the Apple menu, press System Preferences. • Select Keyboard.

• On the Keyboard tab, select the check box for Use all F1, F2, etc. Keys as standard function keys.

Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Starter 2010 When you move or copy rows and columns, Excel moves or copies all data that they contain, including formulas and their resulting values, comments, cell formats, and hidden cells. If the cell contains a formula, the cell reference are not adjusted. Therefore, the contents of the moved or copied cell and of any cells that point to them might display the #REF! If that happens, you will have to adjust the references manually.

For more information, see. You can use the Cut command or Copy command to move or copy selected cells, rows, and columns, but you can also move or copy them by using the mouse. Follow these steps to move or copy cells: • that you want to move or copy. • Do one of the following: • To move rows or columns, on the Home tab, in the Clipboard group, click Cut.

Keyboard shortcut: Press CTRL+X. • To copy rows or columns, on the Home tab, in the Clipboard group, click Copy.

Keyboard shortcut: Press CTRL+C. • Right-click a row or column below or to the right of where you want to move or copy your selection, and then do one of the following: • When you are moving rows or columns, click Insert Cut Cells. • When you are copying rows or columns, click Insert Copied Cells.