MUST USE EXCEL SHORTCUTS
| Apply borders to cells | Ctrl +shift +& | Cmd+Shift +& |
| Auto sum selected cells | Alt + = | Opt += |
| Create a new workbook | Ctrl +N | Cmd +N |
| Create a new worksheet | Shift + f11 | Shift + f11 |
| Create a pivot table | Ctrl + Shift +P | Cmd+shift +P |
| Duplicate data in the cell below | Ctrl +D | Cmd +D |
| Enter the current Date | Ctrl +; | Cmd +; |
| Enter the same data in all cells | Ctrl + Enter | Cmd +Enter |
| Find data | Ctrl +F | Cmd +F |
| Force calculate all worksheets | Ctrl +Alt+f9 | Cmd +Opt +F9 |
| Insert a note | Shift + f2 | Shift +f2 |
| Insert hyperlink | Ctrl +K | Cmd+K |
| Open a workbook | Ctrl + O | Cmd +O |
| Open a format cells window | Ctrl +1 | Cmd +1 |
| Save a workbook | Ctrl +S | Cmd +S |
| Select all cells above | Ctrl +Shift +Up arrow | Cmd +shift + up arrow |
| Select an entire column | Ctrl + Space bar | Cmd +space bar |
| Select the rest of a column | Ctrl + shift +Down-arrow | Cmd +shift +down arrow |
| Select the rest of a row | Ctrl +shift +Right arrow | Cmd +Shift +Right arrow |





Leave a Reply