Google Sheets

Macros using Scripts:

. We can write Macros in Google Sheets by writing scripts.

. Consider in a row, Age needs to be incremented or decremented by using a symbol.

. For this, we need to write script.

  > Select Tools
  > Script Editor

. In the script editor, create a function to increase and decrease values.

. Now to insert a symbol:

  > Select Insert

  > Drawing

  > Choose Shapes and draw.

.  Now assign the script code to the drawn element:

   > Right Click on drawn element

   > Choose Assign Script

   > Mention the name as written in script.

. We get the output which increases and decreases the age as we click on elements.

. Google Sheet allows to make a option button/ checkbox/ drop-down list with the help of Data Validation.

Example:

We can  assign a drop-down to select a City.

  > Select the cell where you want to insert drop-down

  > Go to Data

  > Data Validation

. Now a window appears, select Cell range.

. In Criteria, select List of items.

. Now, assign the values you want to see in the list.

. Finally, we can select any of the items present in the list.