Sheets

When you enter data into a spreadsheet, you may need to make room for more. You might want to insert one or more columns to include additional data. We’ll show you how to add columns in Google Sheets, including how to insert a single column to the left or right and how to add multiple columns to your sheet. Add a single column in Google SheetsVisit Google Sheets, sign in with your Google account, and open the workbook to the sheet you want to use. Step 1: Choose a column adjacent to the one you want to add. You…

Store data in tables and gain insights from graphsThree Sisters companion planting technique by Anna Juchnowicz is used under the Creative Commons Attribution‐ShareAlike 4.0 License (CC BY‐ SA 4.0)Even though there was enough food for 10 billion people, 10% of the world population still regularly goes to bed hungry. Climate change, COVID-19, and the war in Ukraine have exacerbated the food crisis. While feeding the world population (8 billion in 2022) has already been hard enough, producing and distributing enough food…

Google Sheets comes with some useful features and functions, one of which is the ability to merge cells. You can combine cells in Google Sheets into a single, larger cell, just like in Microsoft Excel. When you are out of room or need to create a cell that spans multiple columns or even rows, you may want to merge a cell with others. When working with large spreadsheets, this feature can ease your task.This cell-merging tool is not limited to horizontal merging in sheets; you can also merge cells in a vertical…

Seven and a half years ago, the day after Labor Day, I started a new job. Production assistant for a new TV Network that had yet to air a single hour of programming. Along with just over 20 others, we were to launch a 24-hour network within 30 days. Our first day live was to be October 1st, 2014.I was paid absolutely minimum wage for what was a full-time job at the time. The lowest amount that they could legally pay me. If not for the law, they would have paid me less.And then just a couple of years later I was making…

Microsoft's Office files have not always been the most compatible file types when used with Google's Workspace tools such as Docs, Sheets, and Slides. Thankfully, Google will now warn users about known compatibility issues as soon as they start working on them, letting them take a call if they would like to proceed with editing the document, knowing the risks involved. The feature is currently seeing a gradual roll out and may take up to 15 days to reach users.To make it clear, the incompatibility indicator has existed in…

There may be times when the data you enter into your Google spreadsheet is inconsistent, which might take some time to make the cell contents consistent. In these situations, the drop-down list feature is helpful as it speeds up standardised data entry in Google Sheets. This feature is available on Google Sheets for desktop via web browser or in the mobile app on Android or iOS. How can the dropdown list feature help you?The in-cell drop-down list functions best when the possible data entry options for a cell are both…

Google Sheets is one of the important productivity online tools. The online spreadsheet allows users to do a range of things including create, edit spreadsheets and more. However, there are a lot of commands that may appear time-consuming. To help you use Google Sheets like a pro, here are 15 important desktop shortcut keys. Google Sheets is one of the important productivity online tools. The online spreadsheet allows users to do a range of things including create, edit spreadsheets and more. However, there are a lot…

A Cloud Functions recipe for sentiment analysisPhoto by jkozoski on UnsplashTLDRWe will be discussing how to set up a basic workflow to perform simple sentiment analysis on text in Google Sheets. Specifically, we will be:Using Python and the Google Sheets API to read comments data in a spreadsheetApplying VADER (Hutto & Gilbert, 2014), an open-source sentiment analyser from the nltk package to perform sentiment analysisWriting the results to another tab in your Google SpreadsheetBONUS: deploying the Python code to…

If you’re trying to decide on a spreadsheet application, it’s likely that Google Sheets and Microsoft Excel have made their way onto your list of options. After all, these are two of the most popular and widely used spreadsheet tools on the market. So, what makes one better than the other? Is it a matter of features, access, cost, collaboration, or something else? To help you decide which one is best for you, we’ll break down these categories in our Google Sheets versus Excel comparison. The basics It’s worth stating…

With the launch of Android 12L earlier this year, Google made its intentions clear to make Android tablets and foldable devices more productive and user-friendly. The company promised to overhaul the design of 20 of its apps so that they could take advantage of bigger screens. Today, the company is rolling out updates to some of those apps. Google’s Workspace apps, including Google Docs, Google Drive, Google Keep, Google Sheets, and Google Slides, are the first to receive tablet-focussed usability optimizations. These…