HOW TO DRAW IN GOOGLE SHEETS ?

Table of Contents

• INTRODUCTION
• WHY WE NEED TO DRAW IN GOOGLE SHEETS?
• WHERE IS THE BUTTON TO DRAW IN GOOGLE SHEETS ?
• HOW TO DRAW IN GOOGLE SHEETS?
• DIFFERENT PARTS OF THE DRAWING WINDOW
• DESCRIPTION
• EXAMPLE: DRAW A CIRCLE IN GOOGLE SHEETS

INTRODUCTION

GOOGLE SHEETS is the Spreadsheet application offered by GOOGLE.

Google Sheets is getting popularity among the users due to its ease of sharing the data with protection and access control.

So, it becomes important to learn the basic techniques in the google sheets which are helpful for our day to day work.

In this article, we are going to learn how to draw in google sheets.

WHY WE NEED TO DRAW IN GOOGLE SHEETS?

Graphics are a very easy way to explain much of the theory with the ease of understanding.

We need to make use of the graphics in different documents for the better understanding of the concepts or data given in the text.

Now there are few ways of using the graphics in the Google Sheets.

1. We can import a ready to use picture which fulfills our purpose.
2. We can create the graphics in any other application and then import it.
3. We can make use of the DRAWING CAPABILITY of the google SHEETS and use it.
4. We can create buttons to run our macros.

In this article , we’ll focus on the WAY NO. 3 in which we can create the graphics by drawing them in the Google Sheets itself.

WHERE IS THE BUTTON TO DRAW IN GOOGLE SHEETS ?

The drawing option is present under the INSERT MENU > DRAWING.

HOW TO DRAW IN GOOGLE SHEETS?

So let us start learning the way to draw in google sheets.

Follow the steps to reach the Drawing Canvas in the google sheets.

• Open the GOOGLE SHEETS.
• Create a new sheet or open the page where you want to draw the graphics.

• The sheet is opened.
• Go to INSERT MENU > DRAWING .
• It’ll open the drawing canvas in the new window.



After the canvas or Drawing window is open, we can draw in the window and import it to our sheet simply.

Let us now learn the different options available in the drawing window.



DIFFERENT PARTS OF THE DRAWING WINDOW

Let us check the different options available in the drawing window.

The following picture gives an overview of the drawing options available



DESCRIPTION

UNDO ACTION:

Reverse the action you just did. If you have created something which you want to reverse, you can use this button. One click will take you one step back.

REDO ACTION:

It’ll repeat the action. It is opposite of undo. If you have reached prior to the action you wanted to reach, you can use it to again go forward.

ZOOM:

Increase the size of the different things [ visually only ]

SELECT:

Select the object and move it or apply other actions.

LINE:

Different types of lines available to be chosen from. We can select and draw these lines.

LINE TYPE	DESCRIPTION
LINE	SIMPLE STRAIGHT LINE
ARROW	A SIMPLE STRAIGHT LINE WITH ARROW ON ONE SIDE
ELBOW CONNECTOR	ELBOW TYPE LINE. A LINE WHICH WILL HAVE TWO RIGHT ANGLE ROTATIONS AS SHOWN IN THE ICON
CURVED CONNECTOR	SAME AS ELBOW TYPE LINE BUT THE CURVES ARE SMOOTH AND NOT RIGHT ANGLED
CURVE	A CURVED LINE
POLYLINE	STRAIGHT LINES WHICH CAN BE USED TO CREATE A POLYGON. KEEP ON CLICKING AND THE NEW POINT WILL BE JOINED TO THE OLD ONE USING A STRAIGHT LINE.
SCRIBBLE	FREE LINE. SIMPLY SCRIBBLE AND A LINE WILL BE CREATED EASILY.

SHAPES:

Choose any shape from the exhaustive list to draw.



TEXT BOX:

Insert a text box. Text box is a separate entity containing the text which behaves as a separate text in the document. It can be rotated, put upon the other text and so on.

IMAGES:

Insert a ready image into the drawing canvas which can be further modified using the tools.

CANVAS::

The working area, where we draw.

STEPS TO CREATE GRAPHICS IN GOOGLE SHEETS

Now, we are acquainted with the drawing screen , it is time to create our first graphics.



EXAMPLE: DRAW A CIRCLE IN GOOGLE SHEETS

Follow the steps to draw a circle in google sheets:

• Open google sheets and open the page you want to insert the circle in.
• Go to INSERT MENU > DRAWING.
• The drawing window or canvas will open.
• Select the SHAPE OPTION.
• Select SHAPE and choose circle as shown in the animation below.
• Click anywhere on the canvas and drag it across, a circle will appear.
• The process is shown in the picture below.

After the circle is complete , click SAVE AND CLOSE in the upper right corner of the screen.



After clicking the save and close, the created graphics i.e. our circle, will be imported into the main document as shown in the picture below.

After the graphics has been added into our sheet , the next issue is the way we want to arrange our graphics. [ or circle in our example ].
In this way, we can insert any shape into our document.



We just discussed the way to draw in Google Sheets.

Further addition will be done in the article.