5 Awesome Google Spreadsheet Formatting Tricks

These easy-to-implement “tricks” will make your Google spreadsheets more functional and attractive!

Tip #1:
Line Break within Cell

How-to:To force a line break (a.k.a. carriage return or hard return) within a cell, use: Control + Enter or Alt + Enter

Example:

Tip #2:
Use Multiple Columns for Hanging Indents

How-To:Use the left column for the number and the right column for the text.Note – Format as “Plain Text” to get “1.” into the cell.
Update – Just found out from Brad Medbery on Facebook that you can begin any text string with an apostrophe and it will automatically format it as “plain text.” Try entering “1.” and then enter ” ‘1. ” and you’ll see the difference!

Example:

Tip #3:
Turn Off Gridlines

How-to:Pull down the View menu to toggle “Gridlines” off and on.Note – It is best to create the page first, and then turn off the Gridlines.