Handling large amounts of text in an Excel spreadsheet

G

Guest

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
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pasting large amounts of text into a cell 2
Merged cells/wrap text 1
Text unwaps with large amounts of text 2
How DO I Increase The Excel Cell Comment Data Capacity? 1
How Should I Handle Large Amounts of Varying Text in Excel??? 2
How Do I Replace Paragraphs With New Paragraphs In Excel? 8
Large amount of text in cells - Problem text.xls (0/1) 2
Pasting Large Amounts of Text 2

Top