Group selected cells: Command + Shift + K.Unhide a row: Command + Shift + Left parenthesis or Control + Shift + Left parenthesis.Unhide a column: Command + Shift + Right parenthesis or Control + Shift + Right parenthesis.Hide a row: Command + Left parenthesis or Control + Left parenthesis.Hide a column: Command + Right parenthesis or Control + Right parenthesis.Remove the selection: Control + Hyphen (-).Once you use the above options for selecting cells, use these shortcuts to edit them or their data. Expand the selection to the last cell used: Control + Shift + End or Control + Shift + Fn + Right arrow.Expand the selection up a screen: Shift + Page Up or Shift + Fn + Up arrow.Expand the selection down a screen: Shift + Page Down or Shift + Fn + Down arrow.Expand the selection to the start of the sheet: Control + Shift + Home or Control + Shift + Fn + Left arrow.Expand the selection to the start of the row: Shift + Home or Shift + Fn + Left arrow.Expand the selection by one cell: Shift + Arrow key.Select visible cells: Command + Shift + Asterisk (*).Save yourself and your mouse a little work with these shortcuts for selecting cells, rows, columns, and screens. Show the Find dialog box: Control + F or Shift + F5.Go to the active cell: Control + Delete.Move to the previous sheet in the workbook: Control + Page Down or Option + Left arrow.Move to the next sheet in the workbook: Control + Page Down or Option + Right arrow.Move a screen to the left: Option + Page Up or Fn + Option + Up arrow.Move a screen to the right: Option + Page Down or Fn + Option + Down arrow.Move down a screen: Page Down or Fn + Down arrow.Move up a screen: Page Up or Fn + Up arrow.Move to the last cell used in a sheet: Control + End or Control + Fn + Right arrow.
Move to the start of a row: Home or Fn + Left arrow.Move between cells (unlocked sheet): Tab key.Move up, down, left, or right one cell: Arrow keys.Moving between cells, sheets, and screens using keyboard shortcuts can get you where you need to be with your data much faster. Moving around your spreadsheets and workbooks But most below are specific to using Microsoft Excel and will make managing your data a breeze.
EXCEL SHIFT CELLS RIGHT 1 MAC
When the pointer becomes a move pointer, drag the rows or columns to another location.Do you use Microsoft Excel on your Mac instead of or in addition to Apple Numbers? If so, knowing some keyboard shortcuts for Excel on Mac can save you time when performing basic tasks in your spreadsheets and workbooks.Īs Microsoft products, Excel, Word, and PowerPoint have some of the same shortcuts. When the pointer becomes a move pointer, drag the rows or columns to another location.Ĭopy and insert Hold down SHIFT and CTRL while you point to the border of the selection. Press CTRL+Z if you don't want to replace a row or column.Ĭut and insert Hold down SHIFT while you point to the border of the selection. When the pointer becomes a copy pointer, drag the rows or columns to another location. Excel doesn't warn you if you are going to replace a column. Press Cancel to avoid replacing.Ĭopy and replace Hold down CTRL while you point to the border of the selection. Excel warns you if you are going to replace a column. When the pointer becomes a move pointer, drag the rows or columns to another location. Select the row or column that you want to move or copy.Ĭut and replace Point to the border of the selection. By default, drag-and-drop editing is turned on so that you can use the mouse to move and copy cells.
0 kommentar(er)
