One of the top Excel tips is getting acquainted with shortcuts. Here are some shortcuts that you may not be aware of. Some of these are universal across Microsoft Office products.

• Ctrl Z: This command undoes the last action you took in the worksheet. You can use the Ctrl Z keyboard shortcut. The backward arrow in the upper left-hand corner of the Excel window. above the navigation menu
• Ctrl Shift up or down arrow: Selects all the cells above (up arrow) or below (down arrow) the selected cell. This only selects cells above and below that have data, so it will not select empty cells
• Shift F11: Creates a new worksheet in your current workbook called “Macro1.” This shortcut is also known as the insert tab shortcut. In Mac OS, you may need to add the Fn key for this shortcut to work
• Ctrl Home: Navigates to cell A1
• Ctrl End: Navigates to the last cell that contains data