Show the Modify Cell Style dialog box: Command + Shift + L.Show the Format Cells dialog box: Command + 1.Decrease the font size: Command + Shift + Left angle bracket (Increase the font size: Command + Shift + Right angle bracket (>).Insert special characters: Control + Command + Space bar.Insert a line break within a cell: Command + Option + Return or Control + Option + Return.Apply time formatting (hour and minute with AM or PM): Control + Shift + At symbol Insert a hyperlink: Command + K or Control + K.Apply date formatting (day, month, year): Control + Number sign (#).Apply exponential number formatting: Control + Shift + Caret (^).Apply percentage formatting: Control + Shift + Percent sign (%).Apply currency formatting: Control + Shift + Dollar sign ($).Apply number formatting: Control + Shift + Tilde (~).Add or remove strikethrough: Command + Shift + X.Add or remove italics: Command + I (capital letter “i”).Like in a word processing app like Microsoft Word, you can format data in your Excel workbook cells and these shortcuts make it simple. Ungroup selected cells: Command + Shift + J.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 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.
Microsoft excel for mac mac#
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.
0 kommentar(er)
