List of Excel Shortcut Keys

Are you tired of spending too much time on basic tasks in Microsoft Excel? Look no further! With these simple keyboard shortcuts, you can streamline your workflow and increase productivity.

1. Selecting from beginning to end of a cell: Press the Ctrl + Home keys to select the entire cell from the insertion point to the beginning or end.

2. Creating a new sheet: Use Alt + Shift + F1 or Ctrl + Y to create a new sheet in your current workbook.

3. Inserting comments: Press Shift + F2 to open a comment box for the selected cell, allowing you to leave notes and reminders.

4. Extending selection: Hold down the Shift key while selecting cells to extend the selection range.

5. Opening Visual Basic Editor: Use Alt + F11 or press Ctrl + Y to access the Microsoft Visual Basic Applications editor for your workbook.

6. Opening Selection Window: Press Shift + F8 to open the Selection window, which allows you to repeat previous actions.

7. Viewing file location: Use the File menu > Properties or press F9 to view the location of your workbook on your system.

8. Undoing actions: Press Ctrl + Z to undo recent actions, and use arrow keys to select what action needs to be undone.

9. Moving to last cell with content: Press Ctrl + End to move to the last cell with data in a worksheet.

10. Freezing columns: Use Alt + Shift + F7 to lock column widths, allowing you to easily scroll through large datasets.

11. Switching between formulas and values: Press Shift + F9 to toggle between showing Excel formulas or their calculated values in cells.

12. Maximizing/Restoring workbook window: Use the maximize button (usually located in the top-right corner of the window) or press Ctrl + Z to restore the original size.

13. Creating new worksheets: Use Ctrl + Shift + F1 to create a new worksheet with a default name, such as 'Macro 1' or 'Macro 2'.

14. Switching between workbook windows: Press Alt + Tab to switch between open workbook windows when multiple workbooks are open.

15. Restoring window size: Use the Restore button (usually located in the top-right corner of the window) or press Ctrl + Z to restore the original size of a selected workbook window.

16. Saving workbooks: Use the Save As option or press Ctrl + S to save your workbook with changes.

17. Printing workbooks: Press Ctrl + P to open the Print dialog box, allowing you to print your workbook.

18. Underlining text: Select text and use Shift + F5 to underline it.

19. Copying from above cell: Use Alt + Enter to copy content from a cell above into the current cell.

By incorporating these Excel shortcuts into your daily workflow, you can significantly reduce the time spent on basic tasks and focus on more complex analysis and reporting in Microsoft Excel.

List of excel shortcut keys