Freezing rows and/or columns is a useful and simple technique to lock rows (or columns) of your spreadsheet so that they remain in view even as you scroll down your datasets. You’re anchoring them in place.
How To Freeze A Row In Google Sheets
Go to the menu: View > Freeze
Choose how many rows or columns you want to freeze:
Continue reading How To Freeze A Row In Google Sheets
In this tutorial, you’ll learn how to merge cells in Google Sheets, when to use merged cells in Google Sheets, the pros and cons of using merged cells, and finally, how to identify them with Apps Script.
Continue reading How To Merge Cells In Google Sheets And When To Be Careful
Whether you’re just starting out with Google Sheets or are a seasoned pro, sooner or later one of your formulas will give you a formula parse error message rather than the result you want.
It can be frustrating, especially if it’s a longer formula where the formula parse error may not be obvious.
In this post, I’ll explain what a Google Sheets formula parse error is, how to identify what’s causing the problem, and how to fix it.
Continue reading When Your Formula Doesn’t Work: Formula Parse Errors in Google Sheets
Goal Seek for Sheets is an Add-On for Google Sheets for doing Goal Seek type data analysis.
In October 2019, Google launched an official Add-On, called “Goal Seek for Sheets”, and it is that Add-On that this tutorial references.
Continue reading Goal Seek in Google Sheets
This is a story about a bar, 10 regular folks, and the world’s richest man, to explore different measures of average in Google Sheets.
Somewhere along the way, we’ll seek to demonstrate the robustness of the different average measures, but more on that in a minute.
I want you to picture your favourite bar or pub.
For me, it might be a pint of ale at The Dickens Inn, near the River Thames in London:
I should just finish this blog post here, and we could all spend the rest of the day in happy reverie, supping our favourite tipple.
Alas, that won’t do! We have work to do and things to learn, so let’s get started.
Continue reading Understanding Average In Google Sheets With The World’s Richest Person