These easy-to-implement “tricks” will make your Google spreadsheets more functional and attractive!
Line Break within Cell
To force a line break (a.k.a. carriage return or hard return) within a cell, use:
Control + Enter
Alt + Enter
Use Multiple Columns for Hanging Indents
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!
Turn Off Gridlines
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.
Same sheet with and without gridlines:
Use Border Colors!
The index card below was created with:
– a black outer border
– a red bottom border
– blue horizontal borders
Add Free-hand Drawings
1. Pull down the Insert menu to “Drawing.” This will open a new “Drawing” window.
2. In the drawing window, click the “Line” tool and select the “Scribble” option.
3. Draw on the screen.
4. Click the “Save and Close” button.
5 . Move and resize the drawing as desired.