ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   auto row height a cell with wrap text enabled and a lot of charact (https://www.excelbanter.com/new-users-excel/217163-auto-row-height-cell-wrap-text-enabled-lot-charact.html)

RichAll-68

auto row height a cell with wrap text enabled and a lot of charact
 
How do I auto row height cells that have been wrap text enabled to work
correctly?
Scenario is: from a word document I copy and paste the text into an excel
2007 spreadsheet. The cells are wrap formatted and the column width narrowed,
manually, to enable them to fit to A4 paper. Some cells can have as many as
900 characters.
Problem is: the cells auto row height adjusts to the number of characters
but it is cropped and missing some text when print view or printed? I have
tried various formats of the cell alignment but still no good!

Is there a solution as to how I get around this?


All times are GMT +1. The time now is 03:55 AM.

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