| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do I make hard carriage return appear in pivot table?
I had a table in excel that I put into a Pivot Table for better analysis.
One of the columns of data contains text with hard (Carriage) returns. In the pivot table, they no longer appear and the text appears all on one line separated by little squares. How do I make the hard returns appear in the pivot table? |
|
#2
|
|||
|
|||
|
Select the cell (or all the cells that need it)
format|cells|alignment tab|check Wrap text. colebill1997 wrote: I had a table in excel that I put into a Pivot Table for better analysis. One of the columns of data contains text with hard (Carriage) returns. In the pivot table, they no longer appear and the text appears all on one line separated by little squares. How do I make the hard returns appear in the pivot table? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
| How to make a cell return the formatted value in a text string (i. | Excel Worksheet Functions | |||
| How can I make Excel return the text in column A only if there is. | Excel Worksheet Functions | |||
| Carriage Return in Excel | Excel Discussion (Misc queries) | |||
| Carriage return in macros | Excel Worksheet Functions | |||
Linear Mode
