Google Workspace

Have you ever needed to convert a Google Sheets table organized by rows to organized by columns? I had, and I found a really helpful feature to transform columns into rows.

That’s what transposing is all about, let’s see how to use it on google sheets!

One of the great advantages of using Google Sheets is the ability to work in a team/group editing the same shared file. However sometimes giving everyone the ability to edit the full document can be a problem, someone can accidentally edit the wrong cell and damage the document. Fortunately, Google gives us some simple and useful solutions!

When you work on a big spreadsheet, it’s a great resource to be able to navigate it quickly without always using the mouse.
But how do you quickly move in a google sheet? there’s a go-to cell in Google Sheets?I had the same question, and couldn’t find the answer on the google sheet menu. But finally, I found the solution, so here it is for you!

Many of us (if not all), use Google Sheets as a database, and we use it to store data for our projects. But sometimes you need more than just simple data storage. You want to get the value from one cell or range, based on another cell or range. This is where the Lookup function comes into play.
In this tutorial, I will show you how to do that using Google Sheet’s built-in function LOOKUP.

OK, this is a pretty common task! Having a “name” and a “surname” column, and wanting both merged into a single “full name” column. And even if we’re making this specific example, you can use this guide to merge the content of two or more cells regardless of their content being names or something else. I think every google sheets user will need this sooner or later. I needed it so many times!

I found myself in the need of merging two adjacent cells in google sheets without losing the data contained in them. I searched online and found everyone suggesting to download an addon. But then you discover the addon is not completely free, and I don’t want to give access to my data to an addon only to make a simple task. So I found an alternative method to merge two cells joining the content.

Google Sheets is a great tool to save, organize and share data. It can be used for creating spreadsheets or documents that include tables, charts, formulas, etc. The most important thing about this great tool is the ability to easily add text formatting such as bolding, italicizing, underlining, strikethrough. In the following paragraphs, we will

A complete guide on how to add a new line in a cell in Google Sheets using both keyboard shortcuts and functions to insert a line break in a formula.