# How To Wrap Text in Google Sheets: Step-by-Step Guide | Capterra > Keep your spreadsheets functional by learning how to wrap text in Google Sheets. Source: https://www.capterra.com/resources/how-to-wrap-text-in-google-sheets --- IT & Software Development # How To Wrap Text in Google Sheets: Step-by-Step Guide By Lindsey Newman Lindsey Newman Lindsey Newman is a writer specializing in technology and marketing. She is a frequent contributor to trusted business resources including Newegg, QuickBooks... [See bio & all articles](https://www.capterra.com/resources/author/lindsey-newman-guest-contributor/) Published October 3, 2023 5 min read Table of Contents - [What is text wrapping?](#what-is-text-wrapping) - [Why would you want to wrap text in Google Sheets?](#why-would-you-want-to-wrap-text-in-google-sheets) - [How to wrap text in Google Sheets](#how-to-wrap-text-in-google-sheets) - [Additional tips for wrapping text in Google Sheets](#additional-tips-for-wrapping-text-in-google-sheets) - [Get the most out of your Google Sheets experience](#get-the-most-out-of-your-google-sheets-experience) ## Keep your spreadsheets functional by learning how to wrap text in Google Sheets. While Google Sheets’ default text overflow option keeps your spreadsheets neat and orderly, it can make it impossible to read your input.  To prevent your spreadsheets from turning into an unreadable mess, it’s important to know how to wrap text in Google Sheets.  When the content of a cell is wider than the cell’s width, that content overflows beyond the cell’s boundaries. Once you apply text wrapping, the cell's content will be displayed as multiple lines if necessary, making it easier to read and preventing content from being cut off. ## What is text wrapping? Text wrapping in Google Sheets is a formatting option that lets you control how text is displayed within a cell. When you enter text into a cell in a spreadsheet, it might not fit entirely within the visible area of the cell, especially if the text is long.[\[1\]](#sources) When you apply text wrapping to a cell, the content within it wraps to the next line if it exceeds the cell's width. This ensures that all the text is visible within the cell without extending the cell's boundaries. This is particularly useful for cells containing lengthy text or sentences. ## Why would you want to wrap text in Google Sheets? Knowing how to wrap text in Google Sheets is especially useful in business and work scenarios where you're dealing with textual data that might be longer than the width of a cell.  Here are some examples: - **Project management**: When tracking tasks or projects in a spreadsheet, task names or descriptions can be quite long. Text wrapping helps you maintain a clean layout while providing detailed information about each task. - **Data annotations:** When you're analyzing data and need to add annotations, comments, or explanations to specific cells, text wrapping can make sure that your comments are fully visible without needing to expand cell sizes. - **Legal documents:** In legal work, contract clauses, terms, and other textual content can be lengthy. Text wrapping keeps the entire text visible in the cell for easy reference. ## How to wrap text in Google Sheets Whether you need to wrap text in a cell, a row, or a column, the formatting process is fast and easy. Here’s how:  ### How to wrap text in a cell **Step 1:** Select the cell you want to format. If there are multiple, use CTRL + select on a PC and CMD + select on a Mac. _Select "Format" from the top menu. (Image provided by author.)_ **Step 2:** Click on “Format” in the top menu. _"Overflow" is the default style selected—change it to "wrap." (Image provided by author.)_ **Step 3:** Select “Wrapping.”  **Step 4:** Click on “Wrap” to apply the formatting. _Click “Wrap” to format. (Image provided by author.)_ ### How to wrap text in a row or column **Step 1:** Select the row or column that you want to format. **Step 2:** Click on “Format” in the top menu. **Step 3:** Click on “Text wrapping.”  **Step 4:** Select “Wrap.” ### How to wrap text using the toolbar menu You can also wrap text in Google Sheets by using the toolbar menu's text wrapping icon. _Use the toolbar to wrap text faster. (Image provided by author.)_ **Step 1:** Select the "Text wrapping" icon from the toolbar near the right.  **Step 2:** Click on the "Text wrapping" option to apply the formatting. ### How to wrap text automatically **Step 1:** Select the entire sheet by clicking the blank cell between column A and row 1. Alternately, press CTRL + A on a PC or CMD + A on a Mac.  **Step 2:** Click on “Format” in the top menu. **Step 3:** Select “Text wrapping.”  **Step 4:** Click on “Wrap” to apply the formatting.  ## Additional tips for wrapping text in Google Sheets Here are some quick tips for using Google Sheets to wrap text to its fullest potential: - **Try automatic column resizing:** When you apply text wrapping to a cell, consider combining it with the "Auto-Resize Column Width" feature. Double-click the right edge of a column header to automatically adjust the column width to fit the wrapped text content. - **Use shortcuts:** You can quickly apply text wrapping to selected cells using the keyboard shortcut Ctrl + Alt + Enter (Windows) or Command + Option + Enter (Mac). - **Merge cells sparingly:** Avoid merging cells too frequently, as it can complicate data manipulation and sorting. Instead, use text wrapping to accommodate longer text within individual cells. ### How to prevent text from wrapping If you accidentally apply wrap formatting to a cell, row, or column that wasn’t supposed to have it, you can change how the spreadsheet handles overflow text. Even if you’ve already applied wrap formatting, you can follow these steps: **Step 1:** Select the cell, row, or column you want to change. **Step 2:** Click on “Format”.  **Step 3:** Select “Wrapping.” **Step 4:** Click on “Overflow” or “Clip.” Overflowing the text allows it to spill out of the cell while clipping the text ensures that you can’t see any input that doesn’t fit the width of the cell. ## Get the most out of your Google Sheets experience The more you know about Google Sheets, the better you’ll be at using it for your business. Learn the ins and outs of Google Sheets by checking out these Capterra resources: - [Google Sheets Pricing, Alternatives, & More 2023](https://www.capterra.com/p/169718/Google-Sheets/) - [Compare Google Sheets vs. Smartsheet 2023](https://www.capterra.com/compare/79104-169718/Smartsheet-vs-Google-Sheets) - [Compare Google Sheets vs WPS Office 2023](https://www.capterra.com/compare/126794-169718/WPS-Office-vs-Google-Sheets) ## Capterra's 2026 Software Buying Trends Report ### Download our 2026 Software Buying Trends Report to see how successful software adopters avoid disappointment and how your business can, too. * * * ### Was this article helpful? * * * ## About the Author [### Lindsey Newman](https://www.capterra.com/resources/author/lindsey-newman-guest-contributor/) Lindsey Newman is a writer specializing in technology and marketing. She is a frequent contributor to trusted business resources including Newegg, QuickBooks, and Capterra. ### RELATED READING - [Skillfishing: How to Stop Candidates From Using AI to Fake Skills](https://www.capterra.com/resources/skills-based-hiring-guide-skillfishing/) - [Top 5 Project Management Solutions for Project Visualization](https://www.capterra.com/resources/customer-insights-project-visualization/) - [How to Create a Project Plan: Free Template, Steps, and Checklist](https://www.capterra.com/resources/how-to-create-a-project-plan/) - [What is Workforce Planning? Examples and Tips for Small Businesses](https://www.capterra.com/resources/examples-of-workforce-planning/) - [What Is Talent Analytics and How Can It Help You Hire and Retain Better](https://www.capterra.com/resources/what-is-talent-analytics/) - [How AI Onboarding Tools are Reshaping HR Operations](https://www.capterra.com/resources/ai-onboarding-tools-for-hr/) - [Project Resource Management: What PMs Need to Know](https://www.capterra.com/resources/project-resource-management/) - [What is the Difference Between Accounting and Financial Management Software?](https://www.capterra.com/resources/accounting-vs-financial-management/) - [5 Types of Accounting Software and How To Choose the Right One](https://www.capterra.com/resources/types-of-accounting/)