Solved

Excel Text Box - Line Feeds

Posted on 2012-03-28
5
364 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
  • 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 41

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

867 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now