TOOLS
Make life easier
Coefficient - Live spreadsheet connections to 60+ business systems
Lido - Automate your spreadsheets; accurately extract date from PDFs
TransactionPro - quickly import, export or delete data in Quickbooks
beehiiv - my choice for a newsletter operating system
Carrd - free one-page website builder
Transistor - my favorite podcast host
Grouping and Hiding
Do you know what this is?
This is a toggle that lets you hide and unhide rows or columns in Google Sheets.
You can do the same thing in Excel, and it’s very handy, especially when you have a table that’s gotten a bit bloated, but you’re too committed to the data to delete any of it.
There are two ways to hide:
Right-click and select hide row/column
Right-click, select view more cell actions, select Group column/row
If you’re in Excel, the grouping is in a different place, and you’ve got a sweet keyboard shortcut you can use:
Find the manual option in the ribbon by clicking Data, then Group or Ungroup from the Outline section
Or you can be more awesome and just press
SHIFT + ALT + →to group andSHIFT + ALT + ←to ungroup.
VIDEO
For the visual learners among us…
NEXT STEPS
Whenever you’re ready, here’s how I can help:
Work with me
I’m available for consulting projects. Reach out and let’s chat.Business tech stack
Some of my recommendations for software and tools.Personal budget tool
As a subscriber, you get a discount on my personal finance system.YouTube
If you aren’t subscribed yet, come on over to the YouTube channel where all the spreadsheet, automation and productivity tutorials live.
