Merging cells in sheets is really easy. All you have to do is select the cells you want to combine and click the format menu on the toolbar, go to “Merge Cells” and select “Merge all”. In this post, I’ll walk you through how to merge cells vertically and horizontally using both the options menu… Read more How To Merge Cells In Google Sheets (Combine Columns And Rows Like a PRO)
This tutorial aims to give you a definite guide on how to insert checkboxes in Google Sheets. We will go over the basics, as well as some more advanced topics like conditional formatting with checkboxes, assigning custom values, and counting all the values from checkboxes. We will even sum everything we know into a real-live… Read more How To Add Checkboxes In Google Sheets (Real-Life Examples!)
This tutorial aims to give you detailed guidelines on how to round numbers in Google Sheets. There are a few functions in Google Sheets that let you specify how to round numbers, and how many decimal places to display. There’s even a built-in function that will automatically format them if they are too long. This… Read more How to Round Numbers in Google Sheets (Rounding UP and DOWN with Ease!)
This tutorial aims to give you a detailed guide on how to add bullet points in Google Sheets. It should take you around 5-10 minutes to complete. If you’d like to follow along with me feel free to copy this spreadsheet and do the exercises (this step is entirely optional though) How To Insert Bullet… Read more How To Add Bullet Points in Google Sheets (And Create a Numbered List Too!)
Have you ever tried pressing the tab inside a cell, only to be confused when you’re automatically moved to the next cell instead of indenting text? The good news is that you are not alone in your struggles. The bad news is that there is no default indent setting on google sheets. Luckily there are… Read more How to Indent in Google Sheets (3 TAB Key Alternatives!)
This tutorial aims to give you a definitive guide on how to hide, show, and print with or without gridlines in Google Sheets. It should take you around 5-10 minutes to complete. You may follow along using the spreadsheet available here (just make a copy and you are ready to go). How to Get Rid of Gridlines… Read more How to Remove Gridlines in Google Sheets (Ultimate Guide)
If you want to learn how to freeze rows, columns, and panes in Google sheets you are in the right place. In this tutorial, I will teach you how to: keep the top row of google sheets always visible so you can easily see which heading the data is referring to, how to make a… Read more How to Freeze in Google Sheets (Rows, Columns, and Panes!)
If you want to learn how to alphabetize data (or simply stated, put it in ABC order), then you are in the right place. In this tutorial, I’ll teach you how to organize single columns and multiple columns in alphabetical order in Google Sheets. We’ll also look at two methods for automating this process when… Read more How To Alphabetize in Google Sheets (To Keep List In Order)
If you’re used to Excel, new to Google Sheets, or have never created a table before, the task may seem daunting. However, don’t worry! In this article, I will show you how to insert a table into google sheets in just a few simple steps. You will learn the basics of converting data into a… Read more How to Make a Data Table in Google Sheets (Like In Excel!)
If you want to get dark mode (aka night mode) for your Google Sheets you are in the right place. I use dark mode as a developer on a regular basis because it protects my eyes and concentration while I work long hours. When I couldn’t enable a dark theme in the browser, I was… Read more How to Turn on Google Sheets Dark Mode (It’s Easy!)
