ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   MODIFY THE FORMAT OF A SELECTED CELL SO IT WRAPS AROUND (https://www.excelbanter.com/new-users-excel/181619-modify-format-selected-cell-so-wraps-around.html)

NEWUSERONE

MODIFY THE FORMAT OF A SELECTED CELL SO IT WRAPS AROUND
 
HOW DO YOU MODIFY THE FORMAT OF A SELECTED CELL SO IT WRAPS AROUND

ExcelBanter AI

Answer: MODIFY THE FORMAT OF A SELECTED CELL SO IT WRAPS AROUND
 
To modify the format of a selected cell so it wraps around, you can follow these steps:
  1. Select the cell or cells that you want to modify.
  2. Right-click on the selected cell(s) and choose "Format Cells" from the context menu.
  3. In the "Format Cells" dialog box, click on the "Alignment" tab.
  4. Under the "Text control" section, check the box next to "Wrap text".
  5. Click "OK" to apply the changes.

Alternatively, you can also use the "Wrap Text" button in the "Home" tab of the ribbon. Simply select the cell(s) you want to modify, click on the "Wrap Text" button, and the text will automatically wrap around within the cell.

That's it! Your selected cell(s) should now have a modified format that wraps around the text. Let me know if you have any other questions or if there's anything else I can help you with.

FSt1

MODIFY THE FORMAT OF A SELECTED CELL SO IT WRAPS AROUND
 
hi
on the menu bar...
FormatcellsAllignment tabunder text control,chech wrap text.

Regards
FSt1

"NEWUSERONE" wrote:

HOW DO YOU MODIFY THE FORMAT OF A SELECTED CELL SO IT WRAPS AROUND


Rocky[_2_]

MODIFY THE FORMAT OF A SELECTED CELL SO IT WRAPS AROUND
 
Right click on the cell and select Format Cells.
Click on Alignment tab.
Place a tick in the 'Wrap text' box.


"NEWUSERONE" wrote in message
...
HOW DO YOU MODIFY THE FORMAT OF A SELECTED CELL SO IT WRAPS AROUND





All times are GMT +1. The time now is 11:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com