Solved

How to unWrapping text in massive cells in Excel

Posted on 2016-08-27
5
35 Views
Last Modified: 2016-08-28
Hi,

We various excel sheets that have all their cells "wrapped".  We need to unWrap all their cells; how can we do this?
(we know we can select and unwrap but wanted know if there is some sort of shortcut)
0
Comment
Question by:rayluvs
  • 3
  • 2
5 Comments
 
LVL 8

Expert Comment

by:itjockey
ID: 41773257
This is short cut
0
 

Author Comment

by:rayluvs
ID: 41773302
Yes, as stated in our question we know we can select and unwrap, as you have showned.  What we want to know if there is a shortcut like like if you want BOLD a cell you shortcut CRTL-B
0
 
LVL 8

Accepted Solution

by:
itjockey earned 500 total points
ID: 41773304
Alt-H-W
0
 

Author Comment

by:rayluvs
ID: 41773319
it's a bit tricky but seems to work (guess have to get a hang of it) - sometimes it doenst
0
 

Author Comment

by:rayluvs
ID: 41773320
ok got it... its ALT-H, leave H then press W while holding down H
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

911 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

22 Experts available now in Live!

Get 1:1 Help Now