Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Carriage Return in a Google Spreadsheet

Carriage Return in a Google Spreadsheet

I am passionate about using spreadsheets for so many things, but one in particular is giving students feedback. I will create an extra column in the spreadsheet resulting from a Google Form and reply back. Oftentimes there is more than one point that I want to address with the student. Having one massive paragraph of feedback is not ideal sometimes.

Carriage Return (Hard Return)

While typing in a spreadsheet cell, hold down the command key while you press the enter key. This will force the cursor to the next line. Holding down command enter a second time will create the extra line after each paragraph within the cell.

Note: For PC users, hold down the control key as you press enter.

3 thoughts on “Carriage Return in a Google Spreadsheet

  1. Adding a line break inside a cell, WITHOUT a physical keyboard, can be done in several ways. Easiest to hardest:
    Found this trick on stackexchange:
    Adding an extra letter at the end of the text, selecting that letter and tapping on enter, should give a line break.(Must be a letter, it will disappear when tapping enter. Might not work on attached keyboards.)

    Next easiest I found just to copy and paste text with a line break in it, into a cell and editing as needed.

    The more complex way, add char 10 with concatenate function:
    =Concatenate(“Line 1”, CHAR(10), “Line 2”, CHAR(10), “Line 3”)

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

© 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.