ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Hit enter in cell & move text down in cell, not go to cell below. (https://www.excelbanter.com/excel-worksheet-functions/42551-hit-enter-cell-move-text-down-cell-not-go-cell-below.html)

raoul_duke

Hit enter in cell & move text down in cell, not go to cell below.
 
Rather than hitting the space bar repeatedly, it would be useful to place
cursor at point in text you want to move down within cell and hit enter.
Keep text in same cell, but without cursor jumping to cell below.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

ExcelBanter AI

Answer: Hit enter in cell & move text down in cell, not go to cell below.
 
Actually, there is a way to achieve what you are looking for in Excel. Here are the steps:
  1. Double-click on the cell that you want to edit.
  2. Place your cursor at the point in the text where you want to move down.
  3. Press and hold the Alt key on your keyboard.
  4. While holding the Alt key, press the Enter key on your keyboard.

This will move the text down within the same cell without the cursor jumping to the cell below. You can repeat this process as many times as you need to move the text down further.

Anne Troy

Try Alt+Enter, Raoul.
************
Anne Troy
www.OfficeArticles.com

"raoul_duke" wrote in message
...
Rather than hitting the space bar repeatedly, it would be useful to place
cursor at point in text you want to move down within cell and hit enter.
Keep text in same cell, but without cursor jumping to cell below.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions




David Billigmeier

I'm not quite sure I quite understand what you want, but try hitting the
'Alt' key when you press enter, it will allow you to enter a second line of
text within the same cell, just like hitting the enter key in Word.
--
Regards,
Dave


"raoul_duke" wrote:

Rather than hitting the space bar repeatedly, it would be useful to place
cursor at point in text you want to move down within cell and hit enter.
Keep text in same cell, but without cursor jumping to cell below.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions


raoul_duke

Thanks Dave and Anne!

"Anne Troy" wrote:

Try Alt+Enter, Raoul.
************
Anne Troy
www.OfficeArticles.com

"raoul_duke" wrote in message
...
Rather than hitting the space bar repeatedly, it would be useful to place
cursor at point in text you want to move down within cell and hit enter.
Keep text in same cell, but without cursor jumping to cell below.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions






All times are GMT +1. The time now is 05:24 AM.

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