Please let me know if there is anything I need to clarify better. I'd be happy to try and explain why I don't want to have repeated lines to represent the multiple entries in the one cell if you would like. I'd rather have the rows differ in depth depending on how many lines are within the multi-lined cell. It's only when I'm sorting on other columns, that I would not want separate In this case it would be OK to have separate rows for each of the sub-categories. Or in other words, it could sort the rows by the by rows which have the same sub-category. As shown below you go through the normal Text to Column steps (click on DATA ribbon, Text to Column button, then choose Delimited and Next). Then it could be seen which rows match each sub-category of the cells which had the multiple rows. The only trick is that you need to use a shortcut to ‘create’ the line break character using CTRL + J. It would be as if the tool could expand each cell with multiple entries into multiple rows each with only one entry for that cell. I'd like to be able to sort all the rows by the column that has all the cells with possibly more than one line per cell (some cells in a row will have more sub-categories Assuming I can have multiple lines in a single cell within a row. Is this supported? Perhaps in a newer version of Excel? What I don't want to do is repeat the row n number of times if n is the number of lines I'd like in in the one cell. Which are all like subcategories that apply to the selected row. The entire selection should have a dashed line moving around it if you did it correctly d. Click on the bottom cell of that column i. Press and hold the Shift key on your keyboard, and c. Instead, I would like to be able to enter multiple lines in a cell (alll within only one column) Then another window pops up, select your first column and press OK a.
How to shift enter in excel for a new line how to#
I know how to wrap the text in a cell, but that is not what I want.
I would like to be able to add new line(s) to in only 1 cell in a row. They are also useful when you're building timelines. Standard Edition 2003 installed, so my question pertains to my installation of Microsoft Excel 2003. Number lines can help build math skills, using a visual sequence of numbers to teach addition, subtraction, multiplication and division. Note that I work for a large company and have Microsoft Office I have searched for help on-line, and have not been able to find anything related to what I am looking for. And this seems so easy as it’s just holding an extra key. I was instructed by Microsft Chat support to post my question to this forum. 1) Usage of SHIFT+ENTER You can use SHIFT+ENTER to enter the new line in textbox when you composing a message.