?
Solved

Excel Text Box - Line Feeds

Posted on 2012-03-28
5
Medium Priority
?
381 Views
Last Modified: 2012-06-27
When I first insert a text box into an Excel worksheet and begin to enter text the ENTER key acts as a line feed.  After I exit out of the Text Box and return to add additonal information the ENTER key appears to be disabled.  I press the ENTER key and no longer get the line feed I'm looking for.  What is happening and how do I get the ENTER key to establish a new line?  Thank you for your assistance.
0
Comment
Question by:Michael V Bernot
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 3

Assisted Solution

by:nullsquid
nullsquid earned 1000 total points
ID: 37779112
alt+enter often works for excel to enter a new line (alt+cmd+enter on a Mac)
0
 
LVL 5

Author Comment

by:Michael V Bernot
ID: 37779132
When I go into the TEXT box and push Alt-Enter I get a message regarding saving my document.
0
 
LVL 5

Author Comment

by:Michael V Bernot
ID: 37779270
I believe my keyboard is not working properly.  I am having it replaced to see if this is root of the problem.
0
 
LVL 42

Accepted Solution

by:
dlmille earned 1000 total points
ID: 37779619
It probably is your keyboard.  A textbox shape on the worksheet supports freeform text, so regular ENTER is all that is needed to create line feeds.

Dave
0
 
LVL 5

Author Closing Comment

by:Michael V Bernot
ID: 37782566
Thank you for your comments and suggestions.  This site is the BEST for accurate and prompt attention to all the Excel problems that crop up in the course of a busy day.  Your time is greatly appreciated!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question