Line breaks are a way of adding paragraph marks inside a cell itself. In this video, Jess Stratton shows users the keyboard command to add a line break directly to a paragraph inside a cell.
- [Narrator] You can format a cell…using a combination of changing the size of the column,…changing the text wrapper, and inserting line breaks…into the cell itself.…Here's a cell that's quite large,…and it's going off of the cell itself.…So the very first thing I'm going to do…is change the text wrapping of the entire column.…I'll select the column, choose Format from the top menu,…hover my mouse over Text wrapping, and choose Wrap.…This is going to have it wrap the size of the cell,…no matter how wide the column is.…
I can adjust it according to how wide I want it.…It would still be a little more easy to read, however,…if I could add paragraph marks using line breaks.…I can do that by adding one simple command on my keyboard.…I'm going to double-click to start editing the cell itself,…hold the control key down on my keyboard,…and hit the enter key at the same time.…It's going to add a line break.…Now when I hit the enter key, it preserves that line break,…and it acts as a new paragraph in the cell itself.…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Protecting sheets against unwanted changes
- Rearranging rows and columns
- Adding data validation to cells
- Using the image function to easily add images to cells
- Inserting a gauge chart for status updates
- Adding estimate data to Google charts
- Publishing charts to a website
- Using Google Forms to create surveys
- Using Google Sheets add-ons