Hidden rows in Excel are sketchy. They're part of the reason why some people hate Excel.They give Excel a bad name.The most famous example of hidden cells gone horribly wrong was Barclays not …
Ctrl + 1derful!
I call formatting a necessary evil in Excel. It can easily take as long as the analysis itself -- but the nice thing is that good formatting makes for better, quicker data analysis.Keep the Ctrl+1 …
Time for an Excel Timestamping Shortcut
Time for another Excel shortcut, of course! This is related to Ctrl + ; which will give you today's date (demonstration on my Instagram -- be sure to follow @gjmount!)Ctrl+Shift+; will give you …
Continue Reading about Time for an Excel Timestamping Shortcut →
Excel Keyboard Shortcut: Autofit Column Width
Formatting a spreadsheet can be quite time-consuming. But like with many Excel tasks, knowing some keyboard shortcuts can really help.Alt + O,C,A will autofit the width of your selected column. …
Continue Reading about Excel Keyboard Shortcut: Autofit Column Width →
Copy that Worksheet Faster
A regular task in Excel that's quite time-consuming is copying a worksheet. My old method involved right-clicking, visiting a menu, etc. -- too many steps.Here's a quicker way:h/t Mr. Excel XL: The 40 …
Keyboard Shortcut: Rename Worksheet in Excel
Here's a nice keyboard shortcut I recently picked up. …
Continue Reading about Keyboard Shortcut: Rename Worksheet in Excel →