![]() |
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 |
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:
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. |
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 |
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 |
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 02:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com