Microsoft KB Archive/27796

Displaying Contents of Single Cell Across Several Cells PSS ID Number: Q27796 Article last modified on 01-12-1989 PSS database name: D_MPlan

1.x 2.x 3.x 4.00

MS-DOS

Question: I have a cell that is formatted to be 10 characters wide. In this cell I have entered text which contains many more characters than the 10 that can be displayed, given the 10 character width of that column. Is there a way to display the rest of the characters without changing the width of the column or breaking the text into smaller units and putting each unit in a separate cell?

Response: Yes; Multiplan can print and/or display the contents of a single cell across several cells using the “Continuous” choice under Format Cells. To accomplish this, put the highlight on the cell whose contents you want to see displayed across several cells. Execute the Format Cells command and type a colon after the cell reference listed in the “range:” field. Extend the highlight with your direction keys until you have highlighted the number of cells which will be required to display all the characters residing in the first cell. Then hit your TAB key to move to the “format code:” field and choose “Continuous”.

Copyright Microsoft Corporation 1989.