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.
Google Sheets
22 posts
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
How to Highlight Duplicate Data in Google Sheets
Easily highlight (even remove) duplicate data in a Google Sheet using Conditional Formatting.