insert drawing

How to draw a straight line in Google Sheets

If you are using Google Sheets, you may be having some trouble finding how to insert a line. Once you have figured out how to insert it, getting it to be straight can be frustrating. Follow these easy steps to get it done.

Go to Insert, then Drawing.

insert drawing

From here, choose Line.


Now, here’s where the real trick comes in.  If you want to draw a line, go ahead.  But, if you want to draw a straight line, hold down the shift key while you draw!  There it is, a straight line.

straight line

0 thoughts on “How to draw a straight line in Google Sheets

    • An alternative way to do this is to highlight the cells you want the line at and click the window-looking icon next to the fill icon (called “borders” if you hover over it). Then select if you want the line over, under, around, etc. the selected cells. You can also make this line solid, dotted, thicker, etc. 👍

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>