To master these skills, check out CFI’s Free Excel Crash Course.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. We have provided the top time-saving Excel shortcuts for both a PC and a Mac below. Excel shortcuts It may seem slower at first if you’re used to the mouse, but it’s worth the investment to take the time and learn these important shortcuts.Ctrl + G: To jump to a certain area with a single command.10. Ctrl + F: To search for anything in a workbook.9. Ctrl + D: To fill the selected cell with the content of the cell right above.8. Ctrl + C: To copy cells that are highlighted.7. Ctrl + B: To turn highlighted cells bold.6. Ctrl + A: To select all the contents in a workbook.5.
Short Cut For Fill In Excel Free Excel CrashCtrl + U: To underline highlighted cells.17. Ctrl + R: To fill the selected cell with the content of the cell on the left.16. Ctrl + L: To open the create table dialog box.15. Ctrl + K: To insert a hyperlink in a cell.13. Ctrl + I: To italicise cell contents.12. Ctrl + : To enter the current date in a cell.27. Ctrl + Shift + :: To enter the current time in a cell.26. Ctrl + 8: To show the outline symbols.25. Ctrl + 5: To put a strikethrough in a cell.22. Ctrl + 1: To format the cell contents.21. Ctrl + W: To close your current workbook.20. Ctrl + Shift + $: To apply currency formatting.35. Ctrl + Shift + !: To apply comma formatting.34. Ctrl + Shift + To apply time formatting.33. Ctrl + Shift + ~: To switch between displaying Excel formulas or their values in cell.32. Ctrl + Shift + =: To insert columns and rows.31. Ctrl + ‘: To copy the formula from the cell above.30. 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 + Shift + Drag: To drag and insert copy.48. 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. Ctrl + Shift + Spacebar: To select an entire workbook.43. Alt + Page Up: To move the screen towards the left.55. 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. F3: To paste a cell name if the cells have been named.63. Alt + Down arrow: To activate filters for cells.62. Ctrl + F1: To expand or collapse the ribbon.60. Alt + M: To go to the Formulas tab in Ribbon.78. Alt + P: To go to the Page Layout tab in Ribbon.77. 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. Ctrl + Shift + F3: To create names from values in rows and columns.90. 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. Download kodi for a macCtrl + F4: To close Microsoft Excel. Alt + Y + W: To know what's new in Microsoft Excel.100. Alt 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.
0 Comments
Leave a Reply. |
AuthorCorey ArchivesCategories |