Scribd
Upload
14 views

KeyBoard Short Cuts

Keyboard shortcut excel

Uploaded by

manojaggarwal23022017
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
14 views

KeyBoard Short Cuts

Keyboard shortcut excel

Uploaded by

manojaggarwal23022017
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 3

F2 + Ctrl+Shift+Enter activate array formula

Alt+H+B+A apply the border


Alt+D+F+F Apply/Remove Filter
Ctrl+Shift+L Apply/Remove Filter
Alt+A+T Apply/Remove Filter
Alt+H+O+I Auto Column Height
Alt+H+O+A Auto Row Height
Alt+1 Autosave
F3 Call the named range list
Alt+E+A+A/Alt+H+E+A Clear all
Ctrl+W Close the Workbook
Ctrl+Space Column select
Ctrl+D Copy the cell down
Ctrl+R Copy the left data to right
Ctrl+Shift+F3 Create Name Range
Ctrl+(Minus)+©+Enter Delete the column/Row
Alt+H+D+C Delete the column
Alt+H+D+R Delete the Selected Rows
Alt+E+L Delete the worksheet
F2 Edit the cell
Ctrl+E Flash Fill
Ctrl+G Goto Window
F5 Goto Window
Ctrl+Zero Hide the column
Ctrl+9 Hide the row
Shift+F2 Insert the comment
Shift+F11 Insert the Worksheet
Alt+H+I+S Insert the Worksheet
Ctrl+F3 Name Manager Dialog Box
Alt+H+V+V Paste Special Dialog Box
Shift+F10+V Paste Special Dialog Box
Alt+E+S+V Paste Special Dialog Box
Ctr+Alt+V Paste Special Dialog Box
Alt+H+B+N Remove the border
Alt+H+H+N Remove the interior color
Alt+H+O+R Rename the worksheet
F4 Repeat the last action
Shift+Space Row select
F12 Saveas Dialog Window
Ctrl + Shift + ! To apply comma formatting
Ctrl + Shift + $ To apply currency formatting
Ctrl + Shift + # To apply date formatting
Ctrl + Shift + % To apply percentage formatting
Ctrl + Shift + @ To apply time formatting
Alt + F + C: To close and save your workbook
Ctrl + F4: To close Microsoft Excel
Ctrl + H: To find and replace cell contents
Ctrl + K: To insert a hyperlink in a cell
Ctrl + I To italicise cell contents
Ctrl + A To select all the contents in a workbook.
Ctrl + U: To underline highlighted cells
Ctrl+1 Format Window
Alt+I+C Insert the column
Alt+I+R Insert the Row
Alt+H+F+G Increase the font
Alt+H+F+k Decrease the font
Ctrl+P Print Out
Alt+A+SA Ascending Order- Sorting
Alt+A+SD Descending Order - Sorting
Ctrl+T Create the Table
rmatting

formatting

ur workbook

ell contents
in a cell

ents in a workbook.
ted cells

You might also like