Best 5 Google Sheet Tips and Tricks

It is very simple to implement “tricks” as it makes your  Google Spreadsheet more attractive and function effectively.
How to Insert Line Break within Cell

Press Alt + Enter

or

Press Control + Enter

Google Spreadsheet Formatting

How To Hang Indents use Multiple Columns

Utilize the left column for the number and the right column for the content.

Note – Format as “Plain Text” to get “1.” into the cell.

Overhaul – Just discovered from Brad Medbery on Facebook that you can start any content string with a punctuation and it will consequently organise it as “plain content.” Try entering “1.” and afterward, enter ” ‘1. ” and you’ll see the distinction!

Utilise the right column for the content and left column for the number.

Note : To get “1.” Format as “Plain Text” into the cell.

Google Spreadsheet Formatting

How To Turn Off Gridlines

Pull down the View menu to flip “Gridlines” off and on.

Google Spreadsheet Formatting

Note – It is best to make the page, to begin with, and afterwards kill the Gridlines.

Google Spreadsheet Formatting

How To Use Border Colors

Google Spreadsheet Formatting

The list card underneath was made with:

– a dark external outline

– a red base outline

– blue level outline

Google Spreadsheet Formatting

How To Add Free Hand Drawings

Google Spreadsheet Formatting

1. Pull down the Insert menu to “Drawing.” This will open another “Drawing” window.

2. In the drawing window, tap the “Line” instrument and select the “Scribble” choice.

3. Draw on the screen.

4. Tap the “Save and Close” catch.

5 . Move and resize the drawing as craved.

Google Spreadsheet Formatting

 


You May Also Like: Top 6 Google Sheet Tips and Tricks