Apps How to Use People Chips in Google Sheets Insert People Chips in Google Sheets to tag a person inside a cell to view their contact information and to connect with them in a jiffy.
Apps How to Use Formula Suggestions in Google Sheets Use new Formula Suggestions feature to auto-complete formulas in Google Sheets by typing the “=" sign in the cell.
Apps How to Find Duplicates Between Two Columns In Google Sheets You can find and highlight the duplicate entries between two columns using the Conditional Formatting feature in Google Sheets.
Apps How to Wrap Text In Google Sheets Learn how to wrap text in Google Sheets to show all of the cell's contents in a single cell by adjusting the height of the cell.
Apps How to Use SUMIF in Google Sheets This tutorial provides a detailed demonstration of how to use SUMIF and SUMIFS functions in Google Sheets with formulas and examples.
Apps How to Convert an Excel File to Google Sheets You can convert Excel files to Google Sheets by importing an Excel file, by opening it in Google Drive, or while uploading to Google Drive.
Apps How to Create a Pie Chart in Google Sheets This tutorial covers everything about creating, editing, customizing, downloading, and publishing a Pie Chart in Google Sheets.
Apps How to Insert a Drop Down Menu in Google Sheets You can create a Drop-Down List in Google Sheets using the list of items in a range of cells or by manually entering the items.
Apps How to Hide and Unhide Rows or Columns in Google Sheets You can easily hide and unhide rows or columns in Google sheets, so you don’t have to show irrelevant or sensitive data in your worksheet.
Apps How to Set Print Area in Google Sheets In Google Sheets, you can set the print area to print everything in the workbook, the current sheet, or selected cells. Learn how to do it.
Apps How to Total a Column in Google Sheets using SUM Function In Google Sheets, you can sum or add numbers, cells, ranges, columns, or rows using the built-in SUM function.
Apps How to Make a Gant Chart in Google Sheets Google Sheets doesn’t provide an in-built Gantt chart type, but you can create a Gantt chart by customizing the Stacked Bar chart.
Apps How to Create a Sidebar in Google Sheets Let us show you how to create a custom HTML sidebar (UI Widget) within Google sheets using Google Apps Script editor.
Apps How to Search in All Sheets in Google Sheets This tutorial demonstrates how to search for specific words and phrases across all sheets in Google Sheets using Find and Replace tool.
Apps How to Highlight Duplicate Data in Google Sheets Easily highlight (even remove) duplicate data in a Google Sheet using Conditional Formatting.
Apps How to Make Google Sheet Cells Bigger Enlarge the size of the cells in Google Sheets so that the data appear clear and easily accessible within few simple steps.
Apps How to Link a Google Form to a Google Sheet Access your responses from Google Forms in a systematic manner by linking the Google Form to Google Sheet.
Apps How to Lock a Google Sheet Learn how to lock a particular data range or an entire Google Sheet from being edited by anyone who has read/write access to it.
Apps How to Freeze a Column and Row in Google Sheets Effortlessly track data in your spreadsheet by freezing important rows and columns in Google Sheets
Apps How to Import Data from One Google Sheet to Another Seamlessly import data from one Google Sheet to another sheet using the IMPORTRANGE function and keep the data in sync when changes are made.
Apps How to Insert Google Sheet in Google Doc Learn how to link a Google Sheet into a Google Doc file and be able to update data when you make changes in the spreadsheet file.
Google Sheets How to Add Hyperlinks in Google Sheets Adding Hyperlinks is a great way to give readers access to a lot of information without including the content right in that sheet. Google Sheets lets user create links to an external web page, another document, another sheet in the file and even another part of the same sheet. Here