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