Thursday 21 April 2016

Auto adjust the height or Word Wrap


1. Normally when we paste the values in the excel sheet the rows
1.1    heights are increased ; or 

as shown below
1.2        complete sentense is not shown in the cell
 as shown below



Reasons:  
2.   Either formatting of cell is 
2.1 set as " word wrap"

2.2 Not "Left alligned"




3. Solution for automatically adjust the height of all cell
3.1 first "Allign the left side " 
( "Alt+H+A+L" i.e Press "Alt" then "h" then "a" then "l")
 



         3.2 then if there is word wrap then cancel it by clicking the                     wrap icon
                                 ("Alt+H+W" i.e Press "Alt" then "h" then  "w")



                        Its done as below





Summary
1.   Alt+H+A+L" i.e Press "Alt" then "h" then "a" then "l")
2. ("Alt+H+W" i.e Press "Alt" then "h" then  "w")



No comments:

Post a Comment