how to add rows to a list that is within one cell
 

I have a spreadsheet that i need to update (created by someone else).
Some of the cells contain lists (for example list of 10 items in one cell.
Now if I want to add the 11th item i need to add a row to the space in the
cell.
For now i have found a workaround. I just copy and past empty spaces where i
can place my curser. But i am sure there is a way. Hopefully I explained my
problem well. Can someone help?

how to add rows to a list that is within one cell
 

Use alt+enter (hold down the 'alt' key and hit enter). You'll get a new line
within the cell.
--Bruce

"newtoexcel" wrote:

I have a spreadsheet that i need to update (created by someone else).
Some of the cells contain lists (for example list of 10 items in one cell.
Now if I want to add the 11th item i need to add a row to the space in the
cell.
For now i have found a workaround. I just copy and past empty spaces where i
can place my curser. But i am sure there is a way. Hopefully I explained my
problem well. Can someone help?