Solved

Excel Text Box - Line Feeds

Posted on 2012-03-28
5
379 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 250 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 250 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

623 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