This article aims to give you an ultimate guide on how to hide and how show hidden rows and columns in Google Sheets. We go over many different ways of hiding, showing, and finding cells that are hidden. We’ll cover this ground for both desktop and mobile applications. Furthermore, I’ll include some tips on how… Read more How to Hide and Unhide Rows and Columns in Google Sheets
This guide aims to teach you everything you need to know about text wrapping in Google Sheets. In this blog post, we will touch on the various methods of making text fit within a cell for both desktop and mobile devices. Additionally, I’ll try to solve some of the most common issues people come across… Read more How To Wrap Text In Google Sheets (4 Solutions That Work!)
If you ever need to count cells with text in Google Sheets, there’s a simple way to do it. Just use the COUNTA function! In this post, I’ll walk you through how to count cells with text in google sheets and count the number of cells with specific text or values along with a couple… Read more Google Sheets Counting Cells With Text (Quick Guide)
Unmerging cells in Google Sheets is a really simple process that only takes a couple of seconds. Just select the merged cell you want to unmerge, and click on the “merge cells” icon on the toolbar and you are good to go! In this post, I’ll give you a quick rundown of how to unmerge… Read more How To Unmerge Cells in Google Sheets (3 Easy Ways!)
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)
