Solved

Excel Text Box - Line Feeds

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

856 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