MUST USE EXCEL SHORTCUTS

Posted by

MUST USE EXCEL SHORTCUTS

Apply borders to cellsCtrl +shift +&Cmd+Shift +& 
Auto sum selected cellsAlt + =Opt +=
Create a new workbookCtrl +NCmd +N
Create a new worksheetShift + f11Shift + f11
Create a pivot tableCtrl + Shift +PCmd+shift +P
Duplicate data in the cell below Ctrl +DCmd +D
Enter the current DateCtrl +;Cmd +;
Enter the same data in  all cellsCtrl + EnterCmd +Enter
Find dataCtrl +FCmd +F
Force calculate all worksheetsCtrl +Alt+f9 Cmd +Opt +F9
Insert a noteShift + f2Shift +f2
Insert hyperlinkCtrl +KCmd+K
Open a workbookCtrl + OCmd +O
Open a format cells windowCtrl +1Cmd +1
Save a workbookCtrl +SCmd +S
Select all cells aboveCtrl +Shift +Up arrow Cmd +shift + up arrow
Select an entire columnCtrl + Space barCmd +space bar
Select the rest of a columnCtrl + shift +Down-arrow Cmd +shift +down arrow
Select the rest of a row  Ctrl +shift +Right arrowCmd +Shift +Right arrow

Leave a Reply

Your email address will not be published. Required fields are marked *