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.
Google Sheets
25 posts
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
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...