Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.
Sheets Tip 281: Delete Multiple Sheets Simultaneously
Hi Reader,
Welcome to the Google Sheets Tips newsletter #281, your Monday morning espresso, in spreadsheet form!
My annual Black Friday sale officially starts tomorrow! For a limited time, you can enjoy 40% off my Google Sheets, Apps Script, and AI courses and bundles. (Psst, if you can't wait until tomorrow, you can grab the deals early here.)
A big thank you to this week's sponsor who helps keep this newsletter free to read:
➜ News
I.
Another update to the smart chips in Google Sheets: now you can easily convert hyperlinks to smart chips. When your hyperlink matches the text of a smart chip in Sheets, you'll be prompted to convert to a smart chip.
Read more in last week's Workspace Updates Recap
_______
➜ Google Sheets Tip #281: Delete Multiple Sheets At Once
It's a quick and easy tip today!
If you want to delete multiple sheets at once, don't do it one by one. That's slow and tedious.
Instead, hold down the Ctrl key if you're on a PC/Chromebook or the Command key on a Mac and then select multiple sheets at once.
Then, right-click and choose "Delete".
When prompted, click "OK" to confirm that you want to delete all these sheets in one go.
Pro-tip 1: you can hold down Shift (instead of Ctrl/Cmd) and click to select adjacent Sheets. This is really quick to select lots of sheets that are side-by-side: select the first Sheet, hold Shift, select the last Sheet, and voila!
Pro-tip 2: you can also hide, copy, duplicate, and move multiple sheets once you've selected them.
_______
If you enjoyed this newsletter, please forward it to a friend who might enjoy it.
Have a great week!
Cheers,
Ben
P.S. Duck curling
Google Sheets Tips
Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #314, your Monday Tuesday* morning espresso, in spreadsheet form! * arriving on a Tuesday because yesterday was a public holiday in the US (Labor Day) In case you missed it, last week I sent an email about a new membership program I'm launching soon. Over the next few weeks I'm going to send some behind-the-scenes emails with all the details about this program. If you're interested, click here to get them (Does not...
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #313, your Monday morning espresso, in spreadsheet form! I published my first Google Sheets tutorial 10 years ago, in October 2014. Wow, time flies! Since then, I’ve published 250+ free tutorials on my website, 313 editions of this newsletter, and 21 online courses. We live in an amazing age where it’s possible for an individual contributor to reach a global audience with their ideas. I’m incredibly grateful to be able...
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #312, your Monday morning espresso, in spreadsheet form! My sons go back to school this week and I'm looking forward to getting back to a regular routine. The summer was amazing but loooong. After 11 weeks, we're all ready for school to begin. In this newsletter, we're looking at how to use hyperlinks in Google Sheets. And, if you're an advanced user, I've got a spicy formula for you at the end of the newsletter....