18/09/2024
50 Excel Shortcut Keys You Wish You Knew Sooner – Unlock Your Inner Spreadsheet Wizard!
1. **Ctrl + A:** Selects all data in the current region. (Abracadabra! All your data at your fingertips!)
2. **Ctrl + C:** Copies the selected data. (Copycatting made easy!)
3. **Ctrl + V:** Pastes the copied data. (Paste makes waste? Not in Excel!)
4. **Ctrl + X:** Cuts the selected data. (Snip, snip – it's gone!)
5. **Ctrl + Z:** Undoes the last action. (Oops-proof your work!)
6. **Ctrl + Y:** Redoes the undone action. (Second chances for everyone!)
7. **Ctrl + S:** Saves the current workbook. (Save yourself from data disasters!)
8. **Ctrl + P:** Opens the print dialog. (Ready, set, print!)
9. **Ctrl + F:** Opens the find dialog. (Find your data's hiding spot!)
10. **Ctrl + H:** Opens the replace dialog. (Swap 'til you drop!)
11. **Ctrl + B:** Bolds the selected text. (Make it bold and beautiful!)
12. **Ctrl + I:** Italicizes the selected text. (Lean into those italics!)
13. **Ctrl + U:** Underlines the selected text. (Underline your importance!)
14. **Ctrl + N:** Opens a new workbook. (Fresh start, anyone?)
15. **Ctrl + O:** Opens an existing workbook. (Open sesame!)
16. **Ctrl + W:** Closes the current workbook. (Wrap it up!)
17. **Ctrl + R:** Fills the selected cells to the right. (Right on!)
18. **Ctrl + D:** Fills the selected cells down. (Down the rabbit hole!)
19. **Ctrl + ;:** Inserts the current date. (What day is it again?)
20. **Ctrl + Shift + ;:** Inserts the current time. (Time is money!)
21. **Ctrl + Space:** Selects the entire column. (Column takeover!)
22. **Shift + Space:** Selects the entire row. (Row your boat!)
23. **Alt + Enter:** Inserts a new line within a cell. (Line 'em up!)
24. **F2:** Edits the active cell. (Edit like a pro!)
25. **F4:** Repeats the last action. (Encore, encore!)
26. **F12:** Opens the Save As dialog. (Save it your way!)
27. **Ctrl + Arrow Keys:** Moves to the edge of data regions. (Fly through your spreadsheet!)
28. **Shift + Arrow Keys:** Extends the selection by one cell. (Expand your horizons!)
29. **Ctrl + Shift + L:** Applies or removes filters. (Filter out the noise!)
30. **Ctrl + Shift + "+":** Inserts new cells. (Pop in a new one!)
31. **Ctrl + "-":** Deletes selected cells. (P**f, it's gone!)
32. **Ctrl + 1:** Opens the format cells dialog. (Fancy up your data!)
33. **Ctrl + 5:** Applies or removes strikethrough. (Strike it out!)
34. **Ctrl + 9:** Hides the selected rows. (Hide and seek!)
35. **Ctrl + 0:** Hides the selected columns. (Now you see it, now you don't!)
36. **Ctrl + Shift + 5:** Applies the percentage format. (Percentages for the win!)
37. **Ctrl + Shift + $:** Applies the currency format. (Make it rain!)
38. **Ctrl + Shift + ^:** Applies the scientific format. (Get scientific with it!)
39. **Ctrl + Shift + #:** Applies the date format. (Date with destiny!)
40. **Ctrl + Shift + @:** Applies the time format. (Timely ex*****on!)
41. **Ctrl + Shift + !:** Applies the number format. (Numbers game!)
42. **Ctrl + K:** Inserts a hyperlink. (Link it up!)
43. **Ctrl + T:** Creates a table. (Table it up!)
44. **Alt + H + O + I:** Auto fits column width. (Fit like a glove!)
45. **Alt + E + S + V:** Pastes values only. (Value-added!)
46. **Alt + E + S + T:** Pastes formats only. (Format frenzy!)
47. **Alt + H + V + S:** Opens paste special dialog. (Special delivery!)
48. **Ctrl + Alt + V:** Opens the paste special dialog. (Paste with flair!)
49. **Ctrl + Shift + ":":** Enters the current time. (Tick-tock!)
50. **Ctrl + Shift + 9:** Unhides hidden rows. (Unhide and seek!)
