To wrap text in Google Sheets on a Mac, select the cell or cells, then choose Format > Wrapping > Wrap. Sheets will display long cell contents on multiple lines instead of letting them run across neighboring empty cells or appear cut off. You can do this in Google Sheets in a web browser; no special Mac setting or add-on is required.
What You’ll Need
- A Mac with a web browser and access to Google Sheets.
- A spreadsheet containing the text you want to display. If it is not already in Sheets, open or import the spreadsheet first.
- Permission to edit the sheet. If you only have view access, you will need to request editing permission or make an editable copy if that option is available.
Step-by-Step
- Open the spreadsheet. In your browser, go to Google Sheets and open the file. If you have a link, check that you are signed in to the Google account with access. Wrapping changes the cell’s display, not the text itself, so you do not need to make a duplicate copy just to try it.
- Select the cells to change. Click one cell to wrap only that cell. To apply the setting to a range, click and drag across the cells. You can select a whole column by clicking its letter at the top, or select multiple columns by dragging across their letters. For the entire sheet, click the blank square where the row numbers and column letters meet. Select only the area you need if you want to keep other parts of the sheet’s layout unchanged.
- Open the wrapping options. In the menu bar at the top of the sheet, click Format, then point to or open Wrapping. Choose Wrap from the submenu. The exact layout of the menu can vary slightly with browser window size, but the Format menu is part of the Sheets interface. This is the reliable menu route for Google Sheets in a browser on a Mac.
- Check that the text is now on multiple lines. A cell with a long entry should show the words on additional lines within its existing column width. The column usually stays the same width while the row becomes taller to fit the wrapped content. If the text was already short enough to fit, the cell may look unchanged even though Wrap is selected.
- Adjust the column width if needed. Wrapping does not choose the ideal column width for you. If each line is too short, drag the boundary between column letters to widen the column. If the column takes up too much room, drag the boundary in the other direction; the content will generally occupy more lines. This lets you balance readable text against space needed for other columns.
- Adjust row height if some lines are not visible. Sheets normally expands a row to show wrapped text, but a previously set or manually resized row can leave content hidden. Move the pointer to the boundary below the row number and drag it downward, or use the row’s context menu and choose the resize option to enter a height. If you want Sheets to fit the row to its contents, double-click the boundary below that row number.
- Apply wrapping to other cells when appropriate. If the same problem affects a whole table, select the relevant range or columns before choosing Format > Wrapping > Wrap. This applies one display setting to the selection. For example, you might wrap a Notes column but leave short ID and date columns unwrapped so the table stays compact.
- Review the result at the normal viewing size. Scroll through the sheet and look at the wrapped cells alongside nearby rows and columns. Confirm that the full text is visible, rows have not become unnecessarily tall, and important headings remain easy to scan. If the result is not useful, select the cells again and choose another wrapping option or adjust their dimensions.
Google Sheets also offers Overflow and Clip in the same Wrapping submenu. Overflow lets text extend into an adjacent empty cell; Clip limits what is shown to the cell’s width without displaying extra lines. These options affect how content appears, not the underlying cell value. Choose Wrap when you want the full entry displayed inside the cell, particularly when neighboring cells contain data or when you need to read complete notes.
Common Mistakes
- Changing the wrong selection: If only one cell is selected, only that cell changes. If you intended to format a whole column, select its column letter first, or select the full range before opening the menu. If a large selection changes unexpectedly, use Edit > Undo promptly and reselect the intended cells.
- Expecting the column to get wider: Wrap usually keeps the column width and uses extra lines within the row. If the words break at awkward places, increase the column width rather than repeatedly switching wrapping on and off.
- Assuming hidden text has been deleted: Clip or a narrow cell can make text appear missing, but the full value may still be stored in the cell. Click the cell and inspect the formula bar above the grid to check its contents before editing or replacing anything.
- Forgetting manually fixed row heights: A row that was set to a specific height may not grow as expected. Resize it or use the row boundary’s fit-to-data action, then check whether all lines are visible.
- Wrapping every cell without considering the layout: Applying Wrap to a whole sheet can make a table much taller, especially if it contains long descriptions or URLs. Start with the columns that need it, then expand the selection only if the result remains readable.
- Confusing wrapping with a line break: Wrap responds to cell width and can change the number of displayed lines as you resize a column. A manually inserted line break stays at a chosen point in the text, so it is a different tool.
Tips
- Use wrapping for content that needs to stay readable in a table. It is useful for comments, addresses, task descriptions, product details, and other entries that are too long for a single line. Keep compact fields such as short codes and simple quantities on one line where possible.
- Choose the column width before fine-tuning row heights. A wider column may reduce the number of lines in each wrapped cell. Set a practical width first, then check the rows; otherwise, you may spend time sizing rows and have to repeat the work after changing the column.
- Wrap headings selectively. A long heading can be wrapped in its cell so it fits without making the entire column unusually wide. Check that the header row is tall enough and that filters or other header controls remain accessible.
- Use a manual line break only when the break should stay in a specific place. While editing a cell, position the insertion point where the next line should begin and use Command+Enter on a Mac. The line break becomes part of the cell’s text; wrapping may still add further lines if the column is narrow.
- Keep readability in mind when printing or sharing. More wrapped text can create a longer sheet and affect printed page breaks. Before printing, use print preview and check the page layout. For a shared sheet, consider whether readers will view it on a narrow screen, where wide columns may require horizontal scrolling.
- Remember that Google Sheets and Excel are different apps. The steps here use Google Sheets’ browser menus. Excel has its own text-wrapping controls and ribbon, so instructions for Excel may not match the Format menu path in Sheets.
Troubleshooting
The text still looks cut off. First click the cell and confirm that the full entry is present in the formula bar. Then select the cell and reapply Format > Wrapping > Wrap. If the words still do not all show, check the row height: drag the row boundary downward or double-click the boundary below the row number to fit the row to its contents. Also check whether the cell is merged, because merged cells can behave differently when you adjust row height.
The row does not get taller. Make sure Wrap is selected, then try resizing the row manually. If a row has a fixed height, it may need to be resized to reveal all of its lines. You can also try selecting the row and using its right-click context menu to find the row-resize command. If you are working in a filtered or grouped sheet, confirm you are changing the row you intend to change.
The formatting does not change at all. Check that you selected the correct cells and that you have edit permission. A protected range may prevent changes. If you are in a view-only file, ask the owner for access or make a copy if the owner permits it. You can also reload the browser tab if the interface appears stuck, but first make sure any edits have finished saving.
Text appears to overlap neighboring cells. The selected cells may still be set to Overflow, or the adjacent cells may be empty and allowing overflow to show. Select the relevant cells and choose Wrap. If wrapping is already enabled, inspect the row height and column width, and check whether merged cells or unusual formatting affect the display.
The layout looks different from these directions. Confirm that you are editing a Google Sheets file in a browser rather than opening the file in Excel or another spreadsheet application. Menu placement can shift in a narrow browser window; maximize the window or use the top menu bar to locate Format. The wrapping choices remain under Format > Wrapping in Google Sheets.
Frequently Asked Questions
Does wrapping change the text in the cell?
No. Wrap changes how the cell displays its contents. It does not remove words or alter the stored value. Click the cell and check the formula bar if you want to verify the full text.
Can I wrap text in an entire column?
Yes. Click the column letter to select the column, then choose Format > Wrapping > Wrap. You can select more than one column if needed. Consider whether applying the setting to every cell in those columns will make the sheet too tall.
Why did my row become taller?
Wrapped text needs more vertical space when it takes up multiple lines. Sheets generally expands the row to display those lines. If the row becomes taller than you want, widen the column to reduce line breaks or choose a different wrapping option.
Can I wrap text automatically as I type?
Yes, if the cell or range is already set to Wrap, new or edited content in those cells will display using the wrapping setting. You can set the formatting before entering text or apply it afterward.
How do I remove wrapping?
Select the affected cells, open Format > Wrapping, and choose Overflow or Clip. Overflow can show text in empty cells to the right; Clip keeps the display within the cell. Choose based on whether you want overflow visible or contained.
Is the Mac procedure different from the Windows procedure?
For Google Sheets in a browser, the menu path is the same on Mac and Windows: Format > Wrapping > Wrap. Keyboard shortcuts can differ between operating systems, but you do not need a shortcut to apply wrapping.
Related
- How to Create an Automatic Email Signature in Outlook
- How to Compress Pictures in PowerPoint 365
- Compress Photos in PowerPoint to Reduce File Size
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Add a Header in Excel on Every Printed PageTo add a header that repeats on every printed page in Excel for Microsoft 365 on Windows, open…
- Labels in Excel and Word: Mail Merge Step-by-Step GuideTo create a sheet of address or product labels, organize each recipient or item in a separate row…
- Excel Day of Year: Find the Day Number for Any DateTo find the day of the year in Excel, put a real Excel date in A2 and enter…
- How to Double Space in Word on iPadTo double-space text in Word on your iPad, select the text, open the Home tab, tap Line Spacing,…
- Excel Table Styles: How to Apply and Customize ThemAn Excel table style is a coordinated set of formatting applied to an Excel table, such as a…
- How to Archive Emails in Outlook on a MacBook: StepsTo archive an email in Outlook on a MacBook, select the message and choose Archive on the Outlook…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.