Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.
Sheets Tip 363: Sideways Data Entry 🗃🗃🗃
|
Welcome to the Google Sheets Tips newsletter #363, your (* arriving in your inbox on a Tuesday, because it was Columbus Day in the US yesterday.) Almost two years ago, I launched a course called "The AI Playbook for Google Sheets", which explored how to use basic AI inside Sheets. (Fun fact: this was my last course launch!) A lot has changed since then! Today, Gemini and other AI tools can manipulate data, generate formulas, and write automation code with incredible accuracy. And when you pair that with a strong foundation in Sheets, you can build workflows that are more capable than ever before. That's exactly what my newest course, Modern Google Sheets, is all about. It will help you move from the old way of working to this new, AI-infused era of Sheets. It launches next week, on Monday October 20th. I can't wait to show you. Stay tuned! (Newsletter #364 will return on Monday 27th October.) ➜ NewsI. ➜ Sheets Tip #363: A quick way to navigate rangesIn this tip, we look at a quick way to navigate ranges. It's super simple and a surprisingly neat way to enter data. Highlight a range of cells that you want to enter data, e.g. three cells for column headings. Then pressing the Enter key will move you sideways in the highlighted range: (You can also do this by pressing the Tab key, but most of us are more familiar with the Enter key to add data to a cell.) It works with multiple rows too. The Enter key travels down each column in turn, then jumps up to the top of the adjacent column within the highlighted range: Neat! If you enjoyed this newsletter, please forward it to a friend who might enjoy it. Have a great week! Cheers, P.S. A mummified cat? |
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 #372, your Monday morning espresso, in spreadsheet form! Hoping your 2026 is off to a great start! I'm feeling positive and optimistic for 2026, but reality has also kept me grounded ;) I've only had one work day so far (kids were off sick most of last week, thankfully both better) and I'm now under the weather myself. But it's not too bad and hopefully will pass within a day or two. I finally published my end-of-year...
Brought to you by: Hi Reader, Happy New Year! 🎉 Welcome to the Google Sheets Tips newsletter #371, your first Monday morning espresso of 2026, in spreadsheet form! I usually write a year-in-review post over the holidays but this holiday was so busy that I didn't get round to it. It's a valuable exercise to reflect on the year gone and think about what I want to achieve this year. So I'm still planning to write one and will share it when I do. I hope you had a wonderful holiday season and feel...
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #370, your Monday morning espresso, in spreadsheet form! This is the last Google Sheets Tips email for 2025. We're taking a break from publishing for the holidays and will return with Tip 371 on 5th January 2026. Thank you so much for reading and replying to these emails. I love learning from all of you when you write back and share your own tips and tricks (and occasional corrections! 😉 ). In the meantime, I wish you...