Solved

Add a "Return" in a Cell

Posted on 2013-12-12
3
303 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 500 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

708 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

17 Experts available now in Live!

Get 1:1 Help Now