Quickly select ENTIRE range in Spreadsheet

🌟 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!

(click here for the full gif walkthrough)

⌨️ 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

(click here for full gif walk-through)

Pssst

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 😊

Workspace Essentials Posts

Chrome: 3 Hidden Settings I Use Every Single Day

Google Docs: The audio feature you didn't know you needed

Gemini: The 10-second mobile hack I use 5x daily

Google Drive: The Gemini sidebar trick I use daily

Gemini: The Visual Learning Feature Nobody Knows

Google Forms: My 2 favorite underrated features

Google Sheets: Replace Complex Formulas with Plain English

Gmail: Is "Snooze" breaking your inbox?

Google Slides: Building Blocks = Presentation Lego Pieces

Google Docs: Instantly Draft Docs From Your Files

Google Keep: Text Formatting Hits the Web (finally)

Google Gemini: Hidden Quiz Trick I Used at Google

Google Gemini: A Generalist Prompt That Makes You Look Smart

Google Chat: Group Your Chats for Maximum Productivity

Google Gemini: Stop Using the Wrong AI Model

Google Docs: Save Hours with Auto-Refreshing AI Summaries

Google Gemini: Mind-Blowing Trick to Learn Faster with AI

Google Contacts: The Lazy Person's Guide Contact Management

Google Docs: Transform Your Documents with New Cover Images

YouTube: The Screenshot Trick No One Tells You About

Google Chat: Two Simple Tricks Google Doesn't Highlight

Gemini: Unlock Folder-Level AI Power

Google Docs: 2 Hidden Templates that Save You Time

Google Sheets: One Click to Automate Your Formulas

Google Docs: 3 Must-Try Modern Templates!

Google Vids: The good, the bad, and the alternative.

Google Forms: 3 Smart Tricks to Automate Your Workflow

Gemini: My Most Powerful AI Prompt of 2024

Google Chat: Master These 5 Power-User Tips Today

Gemini: Schedule Events Without Leaving Gmail

Google Sheets: Transform Project Management With One Formula

Gemini: The Smartest Way to Extract PDF Data!

Google Slides: (Official) New Templates Just Launched!

Google Docs: Declutter Your Documents in One Click

Gemini: Your Secret Weapon for Sensitive Emails

Google Sheets: This Table Trick Will Blow Your Mind

Gemini: New Technique to Level Up Your Ideas

Gemini: The Ultimate Feedback Prompt

Gemini: Transform How You Work with PDFs

Google Drive: Simplify Your Digital Life with New Scan Feature

Google Sheets: Time-saving Tables tricks

Chrome: Unlock Google Lens for Smarter Browsing

Google Keep: The Checklist Reset Trick You Need

Google Sheets: Tidy Up Messy Data in Seconds

Google Keep: Search via Chrome Omnibox

Google Docs: Steal My Default Font Styles

Google Slides: Avoid Accidental Edits

Gmail: Game Changing Tip + Exclusive Workshop

Google Sheets: Simplify Data Management with New Table Function!

Gemini: The Persona Trick Most Users Miss

[Enterprise] Master Client Personalization with Variable Chips

Google: Declutter Your (future) Inbox in 30 Seconds

Gemini: Unlock Google Docs/Sheets Hidden Power

[Workspace] Visualize Your Ideas in Real Time

Google Docs: A Better Way to Manage Comments

[Workspace] Immersive Presentations using Speaker Spotlight

Gemini: Your New Google Docs BFF

Google Keep: Transform How You Capture Info

[Workspace] Boost Team Efficiency with Templates

Gemini: Automatically highlight duplicates in Sheets

Gemini: The Chrome trick no-one told you about

Chrome: 3 Hidden Features for Productivity

[Workspace] Calendar Co-Hosts Changed My Team’s Workflow

Gemini: Clean Data, Boost Insights

Gemini: Your secret weapon to understand code

Google Chat: Two tips to find relevant messages quicker

[Workspace] Use Slide Recordings to Replace Meetings!

Gemini: 5 Pro Tips for Better Emails

Google Calendar: Tame Your Notifications

Gemini: Generate Unique Images for Your Next Presentation

Google Drive: Do this Security Checkup today

Google Docs: Streamline Workflow with Placeholder Chips

Google Calendar: Export events to Google Sheets

Google Keep: Rescue Accidentally Deleted Data

[Workspace] One-Click Speaker Note Removal in Slides!

Google Drive: Navigate Videos with Ease

[Workspace] Create Custom Icons for Chat!

Google Gemini: Secret to Unlocking PDF Access

Google Gemini: Effortless Product Comparisons!