AuthorSteven ArchivesCategories |
Back to Blog
Excel For Mac Shortcuts10/16/2021
However, we have picked out some of the most useful shortcuts, and we hope this would be worth your time.The shortcut keys differ between Windows and Mac keyboards. 30 keyboard shortcuts Mac users need to know This collection of keyboard shortcuts for macOS can help users get the most from their iMacs, MacBook Pro and MacBook laptops.Before you proceed, note that the list is pretty long but it is by no means a complete list consisting of all the Excel shortcuts. PDF of Excel MAC Shortcuts. Excel MAC Shortcuts Ive taken the most common shortcuts and created a simple pdf for your reference.
![]() Excel Shortcuts Mac Users NeedCtrl + ‘: To copy the formula from the cell above.30. Ctrl + `: To change the view from displaying cell values to formulas.28. Ctrl + : To enter the current date in a cell.27. ![]() Ctrl + Spacebar: To select an entire column.41. Ctrl + -: To delete a selected row or column.40. Ctrl + Shift + _: To remove a border.39. Ctrl + Shift + &: To place borders around the selected cells.38. Ctrl + Shift + %: To apply percentage formatting.37. Ctrl + Drag: To drag and copy a cell or to a duplicate worksheet.47. Ctrl + Shift + O: To select the cells containing comments.46. Ctrl + Shift + F: To open the fonts menu under format cells.45. Ctrl + Shift + Tab: To switch to the previous workbook.44. Alt + Page down: To move the screen towards the right.54. Ctrl + End: To go to the last cell in a workbook.53. Ctrl + Left arrow: To jump back to the first cell in a selected row.52. Ctrl + Right arrow: To go to the last cell in a selected row.51. Ctrl + Down arrow: To jump to the last cell in a current column.50. Ctrl + Up arrow: To go to the top most cell in a current column.49. Alt + Down arrow: To activate filters for cells.62. Ctrl + F1: To expand or collapse the ribbon.60. Ctrl + F2: To open the print preview window.56. Shift + Right arrow: To extend the cell selection to the right.71. Enter: To complete the entry in a cell and move to the next one.70. Ctrl + 0: To hide the selected columns.69. Alt + H + H: To select a fill colour.67. Shift + F2: To add or edit a cell comment.64. Alt + N: To go to the Insert tab in Ribbon.76. Alt + H: To go to the Home tab in Ribbon.75. Page up/ down: To move the screen up or down.74. Shift + Space: To select the entire row.73. Alt + Y: To open the Help tab in Ribbon.83. Alt + W: To go to the View tab in Ribbon.81. Alt + R: To go to the Review tab in Ribbon.80. Alt + A: To go to the Data tab in Ribbon.79. Alt + M: To go to the Formulas tab in Ribbon.78. Ctrl + Alt + F9: To force calculate all workbooks.89. Shift + F9: To calculate an active workbook.87. Shift + F3: To open the Insert function dialog box.86. Mac os x 1068 emulatorAlt or F11: To turn key tips on or off.98. Alt + F + C: To close and save your workbook.97. Alt + F + E: To export your workbook.96. Ctrl + Alt +: To zoom out inside a workbook.94. Ctrl + Alt + +: To zoom in inside a workbook.91. Ctrl + F4: To close Microsoft Excel.
0 Comments
Read More
Leave a Reply. |