|
Google Sheets
| #177
Google Sheets: Time-saving Tables tricks
(you can easily filter previous issues by application!)
Workspace Toolkit v2
Hey friends - Before diving into today's tip, I'd like to announce that V2 of my Workspace Toolkit has officially launched!
Over 12,000 of you have downloaded the first version since August, and after reviewing 1,000+ feedback comments (where I totally did not use Google Gemini to summarize them 😏), I’ve made some improvements.
Onto today's tip for Google Sheets' Tables feature:
A refresher on Tables
Two months ago I shared a few tips and tricks on how to use Google Sheets’ new Tables feature and since then they’ve made quite a few improvements!
Just in case you missed that edition, we can now easily convert raw data into a pretty table with just two clicks (Right Click > Convert to table).
This allows us to access a variety of features such as naming the table (to reference in formulas!) and editing column types (e.g. converting all cells within a column to Dropdown).
New Features
After shortening my “Date & Time” column to just show the “Date,” I can check “Show placeholders.”
Although that doesn’t seem to do much by itself, notice what happens when I click the “+” sign to add a new row:
Date placeholders are created automatically, which saves me the trouble of typing out a date (and risk messing up the format).
Pro tip
- Instead of clicking the “+” icon, you can select any cell from within the table > highlight a row below > Press Cmd/Ctrl+D to create new rows (Cmd/Ctrl+R to create new columns)
Was this forwarded to you? Join Workspace Essentials for free 😉
Want to see more (or less) of this? Let me know your feedback here!
When you’re ready, here are all the ways how I can help.