Brought to you by:

Hi Reader,

Welcome to the Google Sheets Tips newsletter #361, your Monday morning espresso, in spreadsheet form!

I'm excited to share today's tip with you. I came across it years ago but then forgot about it until today. And I'm kicking myself because it's so useful!

I'm pretty sure I'll be using it on a daily basis now... read on to find out what it is.

➜ News

I.
​Last week, Google announced a significant enhancement to formula generation in Gemini for Sheets, making the output more conversational.

​Read more here >>​

II.
​The AI function in Sheets now available in seven additional languages: Spanish, Portuguese, Japanese, Korean, French, Italian, and German.

​Read more here >>​

Brought to you by: Ablebits Shared Email Templates & Signatures for Gmail Create, customize, and share Gmail templates & signatures ensuring consistency and saving time. Ideal for businesses and teams. 📧 Dynamic templates & placeholders 🖋️ Signature management 📎 Automated attachments 📊 Google Sheets integration 👥 Team collaboration & access control ☁️ Secured cloud access ✅ Perfect for educators, marketers, support & HR teams, consultants – anyone who works in Gmail daily. ⭐ 5 stars on Chrome Web Store Try it free – no credit card, no forms. Add to Gmail

➜ Sheets Tip #361: The AMAZING other use case of the shortcut F4

If you regularly create formulas in Google Sheets, then you're probably familiar with the F4 shortcut. It toggles between relative and absolute references in your formula references.

(And if you're not familiar with it, then you'll learn two tricks today!)

But there's another use for the F4 key, outside of formulas, that's perhaps even more helpful!

F4 repeats your last action!

After entering text or applying a format, press F4 to repeat it. F4 will repeat the last action only, and does not work on formulas.

Try this two simple examples to see how it works:

1) Type the word "Coffee" in a cell. Then move to a different blank cell and press the F4 key. The word "Coffee" appears like magic!

2) Add a yellow background color to a cell.

Then highlight a different cell or range and press F4. The yellow background is applied to those cells too!

To be clear, I only use the background cell fill once, for the first cell. All the other cells are filled by pressing the F4 key.

How am I not using this everyday?!?

Well, I will be from now on!

Hopefully you find it useful too.

If you enjoyed this newsletter, please forward it to a friend who might enjoy it.

Have a great week!

Cheers,
Ben

P.S. How one tech worker is fighting back against AI overreach​