Excel Tips
Row, row, row your spreadsheet
You may have seen my tip last week on how to automatically fit column widths to the size of the data (all without having to touch the mouse). This week,...
Row, row, row your spreadsheet
You may have seen my tip last week on how to automatically fit column widths to the size of the data (all without having to touch the mouse). This week,...
KO GSheets with one move
Creating charts to visualize data in Excel sounds boring, right? But you can turn these boring charts into a fun activity with Image Bar Charts, which replace the data bars with...
KO GSheets with one move
Creating charts to visualize data in Excel sounds boring, right? But you can turn these boring charts into a fun activity with Image Bar Charts, which replace the data bars with...
Get REPT
Most functions in Excel are used to calculate a return value, but the REPT function is unique because it can do two things: calculate a return value or create a mini...
Get REPT
Most functions in Excel are used to calculate a return value, but the REPT function is unique because it can do two things: calculate a return value or create a mini...
How to delete blank rows
Welcome to my new series: Go To Special’s Hidden Treasures. If you aren’t familiar with Go To Special, it’s an Excel tool used to select specific cells in a worksheet....
How to delete blank rows
Welcome to my new series: Go To Special’s Hidden Treasures. If you aren’t familiar with Go To Special, it’s an Excel tool used to select specific cells in a worksheet....
Best of both worlds
Ever have a hard time figuring out what to label the top left cell in your data table? It can feel like being stuck between a rock and a hard...
Best of both worlds
Ever have a hard time figuring out what to label the top left cell in your data table? It can feel like being stuck between a rock and a hard...
He’s a 10, but he merges his cells
What’s so wrong with merging cells? I’m glad you asked. Merging cells might seem like a great way to clean up your spreadsheet, but in reality, they cause a lot...
He’s a 10, but he merges his cells
What’s so wrong with merging cells? I’m glad you asked. Merging cells might seem like a great way to clean up your spreadsheet, but in reality, they cause a lot...