Solved

Excel won't wrap

Posted on 2015-01-15
5
128 Views
Last Modified: 2015-01-15
Hi, I want to be able to wrap the text in this cell but it won't let me.  What can I do? ThanksScreen-Shot.jpg
0
Comment
Question by:camtz
  • 3
5 Comments
 
LVL 7

Expert Comment

by:Katie Pierce
ID: 40551671
This might be silly, but you did try to go through "Format Cell", then "Wrap" in the Alignment tab?

Was it grayed out or something?
0
 

Author Comment

by:camtz
ID: 40551672
ps:  If I double click in the cell, all of the paragraph shows up but once I move to another cell, this is what I see.
0
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40551676
It's on the Date format. Change "Date" to "Text".
0
 

Author Comment

by:camtz
ID: 40551680
Yes, I have been there many times and it already shows wrap
0
 

Author Closing Comment

by:camtz
ID: 40551690
Man, you got a sharp eye.  That worked perfectly.  Have never noticed that.  Many thanks.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvieā€¦
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
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.
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.

808 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