Register now or log in to join your professional community.
I personally use ALT + es (paste special), CTRL+1 (Format), F4 (to change cell reference),
Ctrl+ L to create a list
Ctrl+` to Show formulas
Ctrl+; to insert todays date
F11 to insert a chart
F12 to Save As
Ctrl T,
F4,
Ctrl+`
Ctrl+;
Try this one: Shift + F6 or F10: It will show u all the options or you can use the below functions
1. Alt + H = All Options in Home
Cut, Copy, Paste, Format Painter, Font Options, Font Size, Format adjustments, etc
2. Alt + N = All Insert Options
Insert Table, Pivot Table, Shapes, symbols, Word Arts, Headers, Footers, etc
3. Alt + P = Page Layout Options
Colors, Fonts, Themes, Margins, Orientation, Size, etc
4. Alt + M for Formulas, Alt + A for Data Options, etc.
5. Alt + O + C + A = to expand the cell
6. Shift + F2 = Insert/Edit Comment
7. Shift + F3= Search for a mathematical function
8. Alt + F4 = To Close the Excel Program
9. Ctrl + F or Shift + F5 = Search Option
10. Ctrl + H = To Replace
11. Shift + F11= for New Excel Sheet
12. Ctrl + Page Up = To see front Excel sheets
13. Ctrl + Page Down = To see Back Excel sheets
14. Ctrl + P = Print
15. Ctrl + F2 = Print Preview
16. Ctrl + D = To paste the above the cell without copying
17. Ctrl + F9 = Minimise the Excel Sheet
18. Ctrl + F12 = To save the file in certain destination
19. Ctrl + - (Subtract symbol) = To delete the Cell/Row/Column
20. Alt + I + E = To Insert Cell/ Row/ Column
21. Shift + Space bar = To Select the Entire Row
22. Ctrl + Space bar = To Select the Entire Column