ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Handling large amounts of text in an Excel spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/84705-handling-large-amounts-text-excel-spreadsheet.html)

gemini

Handling large amounts of text in an Excel spreadsheet
 
I'm doing research and have large amounts of transcription to paste into
Excel. Some of the text gets cut off in the cell (it's there but I cannot
view it unless I double click on the cell.) When I go to print, how will I
get all of the text to appear?

Thanks

Dave Peterson

Handling large amounts of text in an Excel spreadsheet
 
If you add alt-enters (to force new lines within the cell) every 80-100
characters, then you'll be able to see more in that cell.

But that might be more work than it's worth...

Have you thought of using a table in MSWord. And you'll be able to use all the
power of a word processor to make it look really pretty.

gemini wrote:

I'm doing research and have large amounts of transcription to paste into
Excel. Some of the text gets cut off in the cell (it's there but I cannot
view it unless I double click on the cell.) When I go to print, how will I
get all of the text to appear?

Thanks


--

Dave Peterson


All times are GMT +1. The time now is 03:00 PM.

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