Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I fix Text entries in Excel that get cut off?
When creating notes for my first year law studies, I have come to make simple
spreadsheets in Excel in which I enter my brief notes about the cases. I have the cell format set to "general", with the wrap text feature checked, but Excel seems to "hide" half of the text. It will show the first part, but not the other half in the cell. It is there if I select the cell, but does not appear in the print preview. How can I fix this problem? |
#2
|
|||
|
|||
"JLaw" wrote: When creating notes for my first year law studies, I have come to make simple spreadsheets in Excel in which I enter my brief notes about the cases. I have the cell format set to "general", with the wrap text feature checked, but Excel seems to "hide" half of the text. It will show the first part, but not the other half in the cell. It is there if I select the cell, but does not appear in the print preview. How can I fix this problem? The Excel specification is that only 1024 characters will display on the worksheet and print. Are you using the worksheet to carry out calculations or sorting/filtering? If not, see if you can do the job more easily in Word . |
#3
|
|||
|
|||
By adding lots of alt-enters (to force new lines within the cell), you can see
lots more than the documented 1024 characters. But you may want to consider using a table in MSWord. You can make it look like cells in excel, but you'll have all the power of a real word processor to use (grammar checks??). In fact, you may want to try just copying your excel range to MSWord to see if you have to fix much. JLaw wrote: When creating notes for my first year law studies, I have come to make simple spreadsheets in Excel in which I enter my brief notes about the cases. I have the cell format set to "general", with the wrap text feature checked, but Excel seems to "hide" half of the text. It will show the first part, but not the other half in the cell. It is there if I select the cell, but does not appear in the print preview. How can I fix this problem? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
Replacing text in Excel files on disk? | Excel Discussion (Misc queries) | |||
How do I fix text wrapping in Excel? | Excel Discussion (Misc queries) |