(Besides a macro, it could also be that the workbook has a corruption issue.)Īnother thing to check is if your system has multiple Alt keys. If (1) Alt+Enter works on other workbooks or (2) the problem workbook doesn't work properly on other systems, then chances are good that it is something within the problem workbook. (Get out of Excel and restart it with another workbook.) You should also try opening the problem workbook on a different system. The easiest way to check if this is the case is to see if Alt+Enter works on other workbooks. Next, you should consider that there is possibly some macro running, when the workbook was opened, that is changing how Alt+Enter is supposed to work. You need to do something to cause Excel to believe you are editing the cell the easiest way is to press F2 or start typing something else into the cell. In other words, you cannot just select a cell and press Alt+Enter. Beyond this, you also need to be in edit mode. First, as Mary noted, text wrapping has to be turned on for the cells. There are a couple of things that must be in effect in order for Alt+Enter to work properly.
If this fixes it, you are lucky and can go on your way. If that doesn't work, it is best to just restart your system. Strange as it may sound, it could just be that your computer is "confused." (That isn't an effort at humanizing computers sometimes some setting, internal to the computer, can just get out of kilter.) To rule this out, start by exiting other programs you may have open, particularly other Office programs, such as Word. There are any number of things that could be causing this aberrant behavior. She wonders if there is some other setting she is missing that has made Alt+Enter all of a sudden quit working as it always has in the past. She made sure that the cells she is editing have wrapping turned on, but still no luck. All of a sudden this has stopped working. Then proceed with the split using “ALT” and “ENTER”.Mary has been using Excel for years, and she often uses Alt+Enter to start a new line within a cell.
To avoid this from happening, we can remove the space as shown “Total Revenue($’000)” prior to splitting the text into 2 lines. Note: Depending on where you place the cursor, the space between between the word “Revenue” and ($’000) may skew the word “Revenue” to the left because the space is on the first line or skew the description “($’000)” to the right is the space is on the second line. Hit the “ENTER” key to confirm the change. The text is immediately separated into two lines in a cell. Here is how:ġ) Place the cursor after the word “Revenue” (either by editing the cell using the function key F2 OR point the mouse button at the formula bar immediately after the word “Revenue” and click on the left mouse button).Ģ) Press the button “ALT” together with the “ENTER” key. All we need to is to use the “ALT” key and “ENTER” key together. Unknown to many users, the description can be maintained in two different lines within the cell under all conditions. A fair amount of time is spent just for this purpose. To have a wider column, many users would have to insert sufficient space between “Total Revenue” and “($’000)”. The above method also restrict the user from adjusting the column width at will. Or the text “($” may move to the first line. If this excel file is to be sent to another person, the word Revenue in the line “Total Revenue” may run off to the next line if the users uses another resolution. This method is not reliableīecause the presentation will appear that way only in the creator’s computer. This will cause the text “($ ‘000)” to flow to the next line. How would you do it?One solution used by most excel users is to format the cell with the “wrap text” option and then adjust the column so that the width is just sufficient to display the description “Total Revenue”. “Total Revenue” in one line and “($ ‘000)” in the second line within the same cell (B5). To present your report professionally, you need to separate the description into two lines in a cell, i.e. Separate the text into two lines in a cell
0 kommentar(er)
