However, we have picked out some of the most useful shortcuts, and we hope this would be worth your time.To display the keyboard shortcut list in Google Drive, press Ctrl + / (Chrome OS, Windows) or + / (Mac). There are more than 500 keyboard shortcuts that you can use in Excel but the problem is not all of those can be helpful for you.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. Knowing and using Keyboard Shortcuts while using Excel is one of those Basic Excel Skills that can help you save a ton of time every day. Written by Puneet for Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019.Excel shortcut keys can greatly improve your speed. Find the shortcuts list below: Description. Indicates to tap the previous key, releasing it before pressing the next key.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.
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 + W: To close your current workbook.20. Ctrl + V: To paste anything that was copied.18. Ctrl + U: To underline highlighted cells.17. Ctrl + `: To change the view from displaying cell values to formulas.28. 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 + Shift + &: To place borders around the selected cells.38. Ctrl + Shift + %: To apply percentage formatting.37. Ctrl + Shift + #: To apply date formatting.36. 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. Ctrl + Spacebar: To select an entire column.41. Ctrl + -: To delete a selected row or column.40. 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. Ctrl + Shift + Drag: To drag and insert copy.48. Ctrl + Drag: To drag and copy a cell or to a duplicate worksheet.47. Ctrl + F1: To expand or collapse the ribbon.60. Ctrl + F2: To open the print preview window.56. 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. 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. F3: To paste a cell name if the cells have been named.63. 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. Shift + F9: To calculate an active workbook.87. Shift + F3: To open the Insert function dialog box.86. Alt + Enter: To start a new line in a current cell.84. 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 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 + Shift + F3: To create names from values in rows and columns.90. Set up gmail for mac mailCtrl + F4: To close Microsoft Excel.
0 Comments
Leave a Reply. |
AuthorDenise ArchivesCategories |