Top Excel Tricks: Best 36 Mouse Tricks To Learn In Excel

#Excel #Tricks: 35+ Mouse Tricks to                           learn in Excel

View Contents [hide]

• 1. Double click fill handle to fill down to whole range – 6 Tricks in 1
  • Bonus Tip – Double click fill skipping row(s)
  • Known Issues
  • Bonus Tip – Right click hold and drag
  • Bonus Tip – Hold Ctrl key and drag to copy cells
  • Bonus Tip – Drag fill in reverse direction within selection
  • Bonus tip – Hold Shift key to insert rows / columns
• 2. Double click row / column margin to adjust height and width
• 3. Double click format painter
  • Bonus tip – Multiple rows and columns with multiple formats
• 4. Double click formula bar to expand quickly
• 5. Double click and hold to select cell content
• 6. Double click pivot table item to drill down
• 7. Double click splitter to activate split screen
• 8. Double click office icon to close excel active window
• 9. Double click any tab to minimize ribbon
• 10. Double click worksheet tab to rename
• 11. Double click scroll bar adjuster to expand scroll bar
• 12. Double click the top boundary of selection border to go to the first cell of the same column
• 13. Jump to last row or column in the range
  • Bonus Tip – Selection using double click
• 14. Get in edit mode and double click again and drag to make selection
• 15. Double click in watch window to select that cell
• 16. Show office clipboard task pane on double clicking copy button
• 17. Double click chart to bring up properties dialogue
• 18. Double click embedded object to display respective program’s bar
• 19. Double click top bar of any task pane and it will rest either left or right of the worksheet
• 20. Insert multiple shapes easily
• 21. Lock drawing mode
• 22. Scroll wheel to scroll through ribbon
• 23. Right click worksheet navigation buttons to get a menu and select worksheets
• 24. Select multiple worksheets by holding Shift or Ctrl key
• 25. Quick paste only values of whole column
• 26. Hold down shift key and click to select multiple rows and columns
• 27. Hold down Ctrl key to select specific cells or rows/columns
• 28. Move or modify formula range easily
• 29. Select whole worksheet by clicking the button where rows and columns intersect
• 30. Right click status bar to enable multiple options like average etc.
• 31. Group specific worksheets’ tabs together
• 32. Copy a worksheet
• 33. Change Tab colors of multiple worksheets in one go
• 34. Move column(s) / Row(s) with ease
• 35. Quick copy selection
• 36. Quick select table with/without header
  • Bonus tip: Select the column/rows of table with a single click