Solved

Excel Text Box - Line Feeds

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

813 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

14 Experts available now in Live!

Get 1:1 Help Now