Excel Shortcuts

          1. Use of F9 – Calculate/Recalculate formulas in the active sheet

          2. Use of F4 – Repeat last action multiple times

          3. Use of F4 in Formula bar – Toggle cell reference (Absolute, Relative, Mixed)

          4. Merging Multiple Cells – Merge multiple cells to convert them to one cell

          5. Multiple lines in a cell – Paragraph or new line within a cell Removing Duplicates –

          6. Remove duplicate values from selected data

          7. Use F9 – Calculate/Recalculate formulas in the active sheet

          8. Use Alt+= – To use the Auto-Function Feature in Excel

          9. Use F4 – Repeat last action multiple times

          10. Use F4 in Formula bar – Toggle cell reference (Absolute, Relative, Mixed)

          11. Use Alt+Enter – Paragraph or new line within a cell (Multiple lines in a cell)

          12. Removing Duplicates – Remove duplicate values from selected data

          13. Use Ctrl+9 to hide row(s)

          14. Use Ctrl+Shift+9 to unhide row(s)

          15. Use Ctrl+0 (that's a zero) to hide column(s)

          16. Use Ctrl+Shift+0 (also a zer0) to unhide column(s)

          17. Use Ctrl+; to enter the current date in the active cell

          18. Use Ctrl+Shift+: to enter the current time in the active cell

          19. Use Ctrl+Shift+% to convert numbers to percentage

          20. Use Ctrl+Shift+& to apply border (outline) to selected cell/range

          21. Use Shift+F2 to edit comments in a cell

          22. Use Alt+F8 to open macro dialog box

          23. Use Ctrl+Shift+$ format current cells as Currency

          24. Use Ctrl+Shift+! format current cells as comma

          25. Use Shift+Ctrl+F Activates font face drop down list

          26. Use Shift+Ctrl+P Activates font point size drop down list

LinkShare Referral Program