Tips

Learn time-saving tips & shortcuts that will help you get your job done faster and make you look like an Excel superstar!

Gridlines Freeze Panes Lost in New Window Video Thumb 640

Macros & VBA, Tips, Tips & Shortcuts

Gridlines & Freeze Panes Settings Lost in New Window – How to Fix It

April 10, 2019

Lock Cells Protect Formulas Video Thumb 640

Tips, Tips & Shortcuts

How to Lock Cells for Editing and Protect Formulas

April 4, 2019

View 2 Sheets Side by Side in Same Workbook 640

Tips, Tips & Shortcuts

View Two Sheets Side-by-Side in the Same Workbook

March 27, 2019

Secret Excel Menu for Right Click Paste Values 640

Tips, Tips & Shortcuts

Paste Values with the Right-click & Drag Mouse Shortcut

February 21, 2019

4 Ways to Automatically Sort Drop Down Lists Excel 640

Formulas, Macros & VBA, Power Pivot/Query/BI, Power Query, Tips, Tips & Shortcuts

How to Sort Drop Down Lists Automatically in Excel

February 6, 2019

Split Screen View Video Thumb 640

Tips, Tips & Shortcuts

Tips for Split Screen in Windows & Mac

January 3, 2019

Best Practices for Using Pie Charts

Charts & Dashboards, Tips, Tips & Shortcuts

When to Use Pie Charts – Best Practices

November 13, 2018

Tips for Tabs - Time Saving Shortcuts for Sheets in Excel Workbooks

Keyboard Shortcuts, Tips, Tips & Shortcuts

7 Shortcuts for Working with Worksheet Tabs in Excel

October 17, 2018

Custom Keyboard Shortcuts to Select the First or Last Sheet in Excel

Macros & VBA, Tips, Tips & Shortcuts

Create Keyboard Shortcuts to Select the First or Last Sheet in Excel

October 17, 2018