bkmor.blogg.se - february 2023

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 the sheet: Control + Home or Control + Fn + Left 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. 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.