Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Add a "Return" in a Cell

Posted on 2013-12-12
3
Medium Priority
?
360 Views
Last Modified: 2013-12-13
In a cell, I have:
DialVerify Fraud Prevention

And it shows up as (centered):
DialVerify Fraud
Prevention

Same with
MaxMind Fraud Prevention

I would like it to be (centered):
MaxMind
Fraud Prevention

I don't know if you can split the cells or not- if so, how?  All of these are on Column 2 - so they have data in them from B2-H2

Thank you!
0
Comment
Question by:coreybryant
  • 2
3 Comments
 
LVL 23

Accepted Solution

by:
NBVC earned 2000 total points
ID: 39714739
At the point where you want the carriage return, hold the ALT key down and press ENTER.

Make sure that you format the cell, through Format|Cells, then in Alignment tab, pick Wrap text.

You can also pick to Centre the text horizontally...
0
 
LVL 29

Author Comment

by:coreybryant
ID: 39717819
The ALT-ENTER was what I needed.  The center was not working the way the way I needed it.
Thank you!
0
 
LVL 29

Author Closing Comment

by:coreybryant
ID: 39717821
The ALT-ENTER was great!  Thanks!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

927 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