ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   excell - merging cells (https://www.excelbanter.com/setting-up-configuration-excel/116321-excell-merging-cells.html)

flores

excell - merging cells
 
How can I merge cells to create one page and have all the text wrap? I have
merged all the cells on one page and created one merge. As I type text some
of the text merges, and other text does not - all on the same page. Why?
How do I make all the text on each line wrap?

Gord Dibben

excell - merging cells
 
flores

Merging a great block of cells creates one big cell with the limitations of one
cell.

One of those limitations is the amount of viewable text.

You can enter 32767 characters in a cell but only 1024 will be visible or can be
printed.

If you stick an ALT + ENTER carriage return every 100 characters you can
increase this 1024 limit.

Otherwise, use a text box or a Word processing program like MS Word.


Gord Dibben MS Excel MVP

On Thu, 26 Oct 2006 12:53:02 -0700, flores
wrote:

How can I merge cells to create one page and have all the text wrap? I have
merged all the cells on one page and created one merge. As I type text some
of the text merges, and other text does not - all on the same page. Why?
How do I make all the text on each line wrap?




All times are GMT +1. The time now is 12:36 PM.

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