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.
Google Sheets
29 posts
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.
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.
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.
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.
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
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.
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.
How to Add Hyperlinks in Google Sheets
Hyperlinks in Google Sheets are a powerful way to connect your spreadsheet to external resources, other documents, or different parts of your spreadsheet. By adding hyperlinks, you can provide quick access to related information without cluttering your sheet. Here's how you can add, use, and manage hyperlinks in...