How to Create a Dependent Dropdown List in Google Sheets

Dependent Drop-Down List

Dependent dropdown lists are a type of dropdown list where the options available in the list depend on the value selected in another dropdown list. This type of dropdown list is useful when you design data entry forms or create dashboards with options to automatically change their content based on the user’s selection. Using dependent … Read more

Stitching Google Map Images to Create a Large Map

Stitching Google Map Images with Image Composite Editor

The size of the images that can be printed/ captured from Google Maps is limited to the browser window’s dimensions. Therefore, sometimes you may come across situations where you need stitching Google Map images to make large high-resolution Google Maps. Such situations are maybe for printing purposes or any other offline uses. In my previous … Read more

Automate Google Sheet to get Google Map Travel Time and Distance

Automate Google Sheet to get Google Map Travel Time and Distance

Using the DirectionFinder class of Google Apps script, you get directions between locations from Google Maps. This class returns several details, including travel time and distance between the given two locations. In this tutorial, I will show you how to get Google Map Travel Tim and Distance to Google Sheets automatically using Google Apps Script. … Read more

Adding Prefix Text to Microsoft Word Heading Numbering

Adding Chapter Number, Custom Prefix to MS Word Headings

Sometimes you may need to customize Microsoft Word heading numbering and add some text as a prefix to the numbers. For example, you may need to change “1. Introduction” to “Chapter 1: Introduction” by adding the word “Chapter” as a prefix. Here I assume that you have already added numbered multilevel heading styles to your … Read more

These 10 Google Search Tricks can yield more relevant results

Google Search Tricks

Google is the most popular search engine in the world. However, did you know that there are special characters and words that you can include in your search to get even better results? Try following 10 google search tricks and tips on your next google search to get more accurate results. 01. Use quotes (“”) … Read more