🌟 Tip of the week - Select Entire Range to Avoid Mistakes!
DID YOU KNOW:
- Google Sheets and Excel accept ranges like "A1:A" and "A:A" so when you use a formula like =COUNTA(A1:A) you do NOT need to update the range manually if more data is added to that range
This is a GREAT way to avoid manual (aka human) error, since you can just set it once and forget it!
⌨️ Keyboard shortcut
- CMD & OPTION & + (on Mac, on PC I believe it's CTRL SHIFT +)
- Insert a new row or column in Google Sheets / Excel with the formatting (you have to select the header row or column
Want someone to be more productive but don't want to confront them about it? Forward them this newsletter instead and have them subscribe here 😉
Read previous Productivity Pings here 🧠
You can also give me feedback by filling out this form here
If you wanna be REALLY nice you can support me by being a paid member here 😊