Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Sheets: Toggle Text Wrapping

Google Sheets: Toggle Text Wrapping

Google sheets toggle text wrap

Unlike the old Google Sheets, the new Google Sheets does not text wrap by default. When students submit paragraph text to a Google Form, or if your spreadsheet data is long strings of text, you may want to toggle the text wrapping on and off. Toggling the text wrap allows you to view a single students full answer.

Control Option O and then W

control option o w

The keyboard shortcut for text wrapping on a Mac is to hold down the Control, Option and O key. This opens the format menu. After releasing the initial 3 keys, press the W key to choose Wrap.

It will take a little practice to get the workflow down. Click on the first cell that needs text wrapping. Hold down Control and Option and O, release and hit the W key. Read the students work and then repeat the keyboard shortcut to turn off the text wrapping. Use the down arrow to go to the next student. Repeat the text wrap keystrokes.

You can also highlight a range of cells and use the keyboard shortcut to toggle the text wrapping.

Toolbar

If you want to use the toolbar icon for text wrapping, it looks like 4 horizontal lines with an arrow pointing to the 4th line.
Screen Shot 2014-11-13 at 12.40.47 PM

© 2024 All Rights Reserved.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Mar 28th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for a way to create dynamic and interactive digital lessons. The Desmos platform is completely free and allows for any topic to be created or customized.

Exit this pop up by pressing escape or clicking anywhere off the pop up.