ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   A table within an excel cell? (https://www.excelbanter.com/excel-worksheet-functions/158643-table-within-excel-cell.html)

Centrol

A table within an excel cell?
 
I have 5 columns. First 4 need to perform arithmetic functions and the last
column need to perform like a table cell ie can type a few lines, left
aligned. I can have tried wrapping but alignment get messed-up when I
change the column width.

kindly advise. TIA




Ron Coderre

A table within an excel cell?
 
While editing a cell....Hold down the [Alt] key and Press [Enter] to insert
a carriage return.

Example: If you type this....
This is [Alt]+[Enter] an example

It will "break" after "This is".... and "an example" will continue on the
next line in the same cell, like this:

"This is
an example"

Note: You may need to engage Text Wrap if it doesn't turn on automatically.

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"Centrol" wrote in message
...
I have 5 columns. First 4 need to perform arithmetic functions and the
last column need to perform like a table cell ie can type a few lines, left
aligned. I can have tried wrapping but alignment get messed-up when I
change the column width.

kindly advise. TIA







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

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