Sheetgo Blog

Your go-to resource for all things spreadsheet related

Google Sheets Keyboard Shortcuts (Guide)

We all know the disruption the mouse enabled graphical user interface brought to the world. It was revolutionary. Without a doubt, navigation within the applications has become a lot more intuitive. However, for a regular user, using a mouse to work on Google Sheets...

read more

Allot maximum time that someone can access our Google Sheets

With Google Sheets application, we know we can easily share the spreadsheets with people. And they can effortlessly access and work on them from any device or location. It is noteworthy to see that the Google Sheets' Share functionality, by default, lets people access...

read more

Google Sheets permission levels

Google Sheets is built around one central pillar - collaboration. This cloud-based application is at the forefront leading this innovation to make it as simple and as ubiquitous as possible. One just needs to have a browser to access the Google Sheets, as it is both...

read more

How do I get notified if someone edits my Google Sheets?

Google Sheets has already made data management pretty easier to handle. We can share the spreadsheets across teams and grant necessary access permissions to effectively control who can view and edit the data. But Google Sheets stepped it even further. I can also get...

read more

How do I validate input values in Google Sheets?

Google Sheets is built around the central fabric called collaboration. Therefore, it is a commonplace that multiple people work on a single Google Sheets file. And when doing so, we may have to restrict people from entering unwanted values in cells, accidentally or...

read more

5 Simple Rules for Data Visualizations

Please, stop sending your colleagues spreadsheets! Data is meant to tell a story, so creating dashboards allows you to select the specific data to customize your storytelling to your target audience. Here are 5 Simple Rules for Data Visualizations to help...

read more

How to create pivot tables in Google Sheets?

One of the prime reasons we use spreadsheets is store data. However, it isn't as useful just to store the data if we are not able to derive insights from it. Google Sheets comes with tools that help us analyze the data and convert it into a more meaningful insight. In...

read more

How do I protect cells or pages in Google Sheets?

With the advent of the Internet and cloud-based technology, collaboration and information exchange have become a breeze. Google Sheets has been the leader in the spreadsheets space. As easy as it has become to work on these ubiquitous...

read more

How to create an alternated colors list in Google Sheets?

While working with data on Google Sheets, it sometimes gets very difficult to read the data. More so, when there are a huge number of rows and columns to deal with. This is because, by default, the spreadsheet real estate is monotonous in color. To deal with this,...

read more

How do I name ranges or cells in Google Sheets?

Spreadsheets are made up of cells that can hold many types of data. And they usually are referenced using the R1C1 notation, for e.g. B4, or N6. And a group of cells is referenced in this notation R1C1:R2C2, for e.g. B2:C6. In practice, we use such references to...

read more

Google Sheets data formats guide

Google Sheets spreadsheets application is designed to hold information of many different types. These data types broadly fall into text, numbers, and dates. The data-format settings define how we see the information on a particular cell. By default, the data format...

read more