?
Solved

Using a Text Field and a CR within a Cell

Posted on 2014-07-21
3
Medium Priority
?
124 Views
Last Modified: 2014-07-21
EE Pros,

I'm using a particular cell in a WS to put in notes about a particular record.  Here's the problem, when I try to add a Carriage Return, it moves my cursor to another cell.  I tried changing the cell type to "Text" but still, I can't do regular typing notation within the cell.  Is there a way to make that particular Column (Text Cells) behave properly so that I can add text and notate correctly (instead of a single continuous stream of notes with no CRs)?

Thank you in advance,

B.
0
Comment
Question by:Bright01
[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 Comments
 
LVL 27

Accepted Solution

by:
MacroShadow earned 2000 total points
ID: 40208935
Alt+Enter will add a Carriage Return.
0
 
LVL 13

Expert Comment

by:duncanb7
ID: 40208981
You can wrap the text line  if the text is too long  by the method similar to the link mentioned at
http://www.officearticles.com/excel/carriage_return_within_a_cell_in_microsoft_excel.htm
one method is mentioned by previous post, see other one.

Duncan
0
 

Author Closing Comment

by:Bright01
ID: 40208991
Thanks guys.... Alt.+Enter works great!

B.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

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;…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
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.

762 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