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:

FORMULA GOD

Chat with your data in Google Sheets using AI ✨

Ask Formula God to analyse your data, create visualisations or walk you through how to solve challenging problems using formulas.

➜ 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.

Read more from Google Sheets Tips

Brought to you by: Hi Reader, Happy Monday! Welcome to the Google Sheets Tips newsletter #346, your Monday morning espresso, in spreadsheet form. This week's tip comes from a reader who emailed in with a question about Tables in Google Sheets. The answer was yet another benefit to using Tables that I hadn't previously noticed. Check it out below, after this week's news and sponsor message. ➜ News I.Staying with Tables... For developers, Tables are now part of the Google Sheets API...

Smart Fill in Google Sheets

Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #345, your Monday morning espresso, in spreadsheet form! A couple of weeks ago I was looking over a Google Sheet with my wife (we help each other with business problems). My wife was extracting town names from a list of addresses and used the Smart Fill feature to automate it. She extracted the first two examples and then Smart Fill did the rest. "Woah, hang on a sec", I said "show me that again." I didn't realize that...

Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #344, your Monday Tuesday* morning espresso, in spreadsheet form! * coming to your inbox on a Tuesday because many folks have a long weekend for Easter. In today's reader-inspired example, we're going to look at a common, but tricky, conditional formatting example: How to highlight values in one range based on activity in a different range? Today we'll look at how to create a conditional formatting rule to highlight...