ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do you print all data in a cell? (https://www.excelbanter.com/excel-worksheet-functions/19520-how-do-you-print-all-data-cell.html)

qznsdwight

How do you print all data in a cell?
 
How do you printe all the data in a cell. Excel only visibily displays up to
1024 characters but you can have more data than that. How do make excell
print the entire cell data?

thanks
dwight

Dave Peterson

Add some alt-enters to force new lines within the cell.
Use smaller fonts.

You can see way more than 1024 characters and print way more, too.

qznsdwight wrote:

How do you printe all the data in a cell. Excel only visibily displays up to
1024 characters but you can have more data than that. How do make excell
print the entire cell data?

thanks
dwight


--

Dave Peterson


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

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