How to break lines in Google Sheets?
It’s happened to all of us and we have a long line in Google Sheets and we need to wrap it somehow. Today I will...
How to apply formula to entire column in Google Sheets?
A very simple question that has a simple answer which we will show today. How to quickly apply the formula to an entire column. We’ll...
Usage emojis in Google Sheets
Today we’ll look at how to use emoticons in Google Sheets, how to insert them into cells and how to use their meaning for quicker...
How to split cells in Google Sheets?
Occasionally you can import data into Google Sheets that does not split itself into columns. Let’s take a look at how to split data in...
How replace part of text in Sheets?
In the next article here on SheetForCorporate we will show how to replace parts of text. If you search the classic sources you will often...
About GoogleFinance function() in Sheets
GoogleFinance is a function in Google Sheets which allows users to retrieve current or historical financial information about stock prices, currency exchange rates, and financial...
How to publish data from a private sheet?
On one of my other websites, I have my stock portfolio page where I want to show my readers how successful my investment is. Today...
Remove duplicates lines from Google Sheets
To remove duplicate lines in Google Sheets, we can use UNIQUE function. This function allows identify and remove duplicate values from a range of cells....
How convert unix timestamp to date in Sheets?
In today’s article, I will show you how to convert Unix time to a readable date time in Google Sheets. Unix time, also known as...
IFERROR function in Google Sheets
Today we will look on function IFERROR which you should use in Google Sheets to fix #N/A as results of other functions. For me IFERROR...
Basic arithmetic function in Sheets
Basic functions that you will use in Google Sheets on a daily basis are arithmetic functions. In today’s article I will show you arithmetic functions...
How find duplicates in Google Sheets?
The COUNTIF or conditional formatting features coul be used how to find duplicates in Google Sheets. In today’s article we will look at this topic...
Adding filters to Google Sheets
If you want to filter the results in Google Sheets, you have two options, either use the =FILTER() function or use the built-in filters. Today,...
Checkbox in Google Sheets
Today we will look at one of the features of Google Sheets and how to create a checkbox and how to work with checkboxes effectively....
Drop-down list in Google Sheets
Today I will show you the drop-down list feature in Google Sheets. How to create a “basic” drop-down list, how to create a drop-down list...
The differences in Google Sheets by countries
The first article on this site will be about the differences between Google Sheets by country. This article is must read for everyone who will copy...