➤ Excel Keyboard Shortcuts

To edit a cell F2
To copy and paste cells Ctrl + C & Ctrl + V
To italicize and make the font bold Ctrl + I & Ctrl + B
To center align cell contents Alt + H + A + C
To fill color Alt + H + H
To add a border Alt + H + B
To remove outline border Ctrl + Shift + _
To add an outline to the select cells Ctrl + Shift + &
To move to the next cell Tab
To move to the previous cell Shift + Tab
To select all the cells on the right Ctrl + Shift + Right Arrow
To select all the cells on the left Ctrl + Shift + Left Arrow
To select the column from the selected cell to the end of the table Ctrl + Shift + Up Arrow
To select all the cells above the selected cell Ctrl + Shift + Down Arrow
To add a comment to a cell Shift + F2
To delete a cell comment Shift + F10 + D
To display find and replace Ctrl + H
To activate the filter Ctrl + Shift + L
To insert the current date Ctrl + ;
To insert current time Ctrl + Shift + :
To insert a hyperlink Ctrl + k
To apply the currency format Ctrl + Shift + $
To apply the percent format Ctrl + Shift + %
To go to the “Tell me what you want to do” box Alt + Q

*To open the create table dialog boxCtrl + L

Provide feedback