-1

I have an excel sheet which I use to write notes. I want either of the two things.

  1. All rows to be multi-line (ideally 2 lines high) so if the content doesn't fit it one row, it automatically wraps to the next line

  2. All rows to be single line except if the content doesn't fit in one row, it automatically wraps to the next line. The only difference is that this will only affect the row which has longer content, instead of all the rows.

Note: I don't want to press Alt+Enter or do anything manually each time. It should happen automatically.

1

Select the area you want to be multi-lined.

Then click wrap text.

enter image description here

4
  • Thanks, worked. Is it possible to wrap the whole sheet all the time without having to click that button?
    – CodePanda
    Apr 7 at 7:50
  • @CodePanda you can select the whole sheet using CTRL+A and then click the button
    – PeterH
    Apr 7 at 8:06
  • The only way to have it more automated than @PeterH's suggestion of setting it for a whole sheet at a time, is to edit the default blank template for Excel. Then all your future new workbooks will at least have this set. See here journalofaccountancy.com/issues/2017/aug/…
    – Mobus
    Apr 8 at 8:40
  • And if you really don't like clicking that button, hit ALT, H, W (in sequence not together).
    – Mobus
    Apr 8 at 8:47
0

I had to dig this out of the Wayback Machine, as the original tech site (http://www.tech-archive.net/Archive/Excel/microsoft.public.excel.setup/2004-06/0118.html) was down. Thought it worth reposting. Credit Gord Dibben.

From: Gord Dibben (gorddibbATshawDOTca)
Date: 06/17/04 
In reply to: L Schmandt: "how to default all cells to wrap text?" 
Date: Thu, 17 Jun 2004 08:15:03 -0700

Hit CRTL + A to select all cells. Format>Alignment>Wrap Text. To make this the default for all new workbooks and sheets.... Open a new workbook. Customize as you wish. File>Save As Type: scroll down to Excel Template(*.XLT) and select. Name your workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT. Store this workbook in the XLSTART folder usually located at........ C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART This will be the default workbook for File>New>Workbook. You can also open a new workbook and delete all but one sheet. Customize as you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes the default Insert>Sheet. More can be found on this in Help under "templates"(no quotes). Gord Dibben Excel MVP

1
  • Updated path under Windows 10 C:\Users\%username%\AppData\Roaming\Microsoft\Excel\XLSTART
    – Mobus
    Apr 8 at 9:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.