Basic shortcuts in excel
To move window Ctrl+F7 To remove the outline border around selected cell Ctrl+Shift+_ To apply/remove strike through formatting Ctrl+5 To move previous pane Shift+F6 To move next pane F6 Move…
To move window Ctrl+F7 To remove the outline border around selected cell Ctrl+Shift+_ To apply/remove strike through formatting Ctrl+5 To move previous pane Shift+F6 To move next pane F6 Move…
To repeat the last action F4 To calculate the worksheet in all open workbook Ctrl+Alt+F9 To rechecks dependent formula Ctrl+Alt+Shift+F9 To define the name Ctrl+F3 To create the names in…
To Adjust Column Width to Fit the Content Alt+O+C+A To Adjust Column Width to Specific Value Alt+O+C+W To Adjust Row Height to Fit the Content Alt+O+R+A To Adjust Row Height…
To insert new worksheet Shift+F11 To save the file Shift+F12 To open the file Ctrl+F12 To give the print Ctrl+Shift+F12 To save the file Alt+Shift+F2 To print the file Ctrl+P…
To repeat the last action F4 To calculate the worksheet in all open workbook Ctrl+Alt+F9 To rechecks dependent formula Ctrl+Alt+Shift+F9 To define the name Ctrl+F3 To create the names in…
Pivot Tables Shortcuts Create pivot table Alt + N, V Select entire pivot table Ctrl + A Group pivot table items Alt + Shift + → Ungroup pivot table items…
Number Formatting Particulars …
Insert new worksheet Shift + F11 Go to next worksheet Ctrl + Pg Dn Go to previous worksheet Ctrl + Pg Up Print Ctrl + P Create new workbook Ctrl…