Excel 2010 - Change the column width and row height - eBay Suspended & PayPal Limited Forums
eBay Suspension & PayPal Limited Forums  
Join Today
Register Subscribe
     

Registration is fast, simple and absolutely free so please, join our community today!


Go Back   Home > General Discussions (Off-Topic) > Everything Else

Everything Else For off-topic conversation. The rules are relaxed in here, but play nice!

Reply
 
Thread Tools
  #1  
Old 01-11-2015
Junior Member
 
Join Date: Jan 2014
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Activity: 0%
Longevity: 47%
iTrader: (0)
Default Excel 2010 - Change the column width and row height

Hi Guys
I have an excel chart , that the column is made of 7 columns (for rating purpose and other options) , anyway , one of the sections has space for comments , this sections is one row made of 4 columns that are centered and merged and text sidled as well as the option of automatic row height but the problem is when i entered text the row height stays the same for the one row made of e,f,g,h and does not gets bigger ...
only when i enter the same long text for column A which is menu column the text on row (made of e,f,g,h) gets changed as well ...


i have a movie explaining the issue but my excel version is in hebrew ...i will attach the movie anyway in case it will help , i will appreciate any help ...

movie link

Thanks
Reply With Quote
The complete step-by-step guide to get back to selling today!

  #2  
Old 01-11-2015
Senior Member
 
Join Date: Jan 2013
Posts: 4,410
Thanks: 242
Thanked 1,583 Times in 1,074 Posts
Activity: 0%
Longevity: 54%
iTrader: (0)
Default Re: Excel 2010 - Change the column width and row height

I'm not exactly sure of everything you said but if your trying to change the height of the row, just go to the beginning of the row to the left and double click and hold and drag up and down that will change the height of the entire Row

If you want to change the width go to the top of the page and double click and hold one of the sides of the column go back and forth and that will change the width of each cell in that one column
Reply With Quote
  #3  
Old 01-11-2015
Junior Member
Threadstarter  
 
Join Date: Jan 2014
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Activity: 0%
Longevity: 47%
iTrader: (0)
Default Re: Excel 2010 - Change the column width and row height

friend
i want the row to be automatically changed according to the length of the text using the automatic row height option. ...
it works with one row , but when i am merging few rows from several columns into one row, then the automatic row height function does not works ...


hope that explanation was better ...
David
Reply With Quote
  #4  
Old 01-12-2015
Senior Member
 
Join Date: Oct 2014
Posts: 342
Thanks: 34
Thanked 71 Times in 60 Posts
Activity: 4%
Longevity: 41%
iTrader: (0)
Default Re: Excel 2010 - Change the column width and row height

If you want the row to auto increase height then you can't merge rows or columns at all.

Merging for just looks purpose is not the best practice in excel. Try instead using text alignment setting of "Center across selection" in format cells menu, be aware this is just for horizontal alignment and there is nothing for vertical alignment
Reply With Quote
Reply



Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Gossip Column for rsot GreenBean Everything Else 9 10-03-2012 09:50 AM
AZ and excel files Nozama Amazon 2 01-31-2012 05:24 PM
Problem with Excel Emanresu Multiple eBay & PayPal Accounts 3 09-06-2011 10:08 AM
Excel search SaiJin Subscriber Discussions 3 11-05-2010 01:28 PM
Christmas 2010 aking eBay Discussion! 12 08-14-2010 10:54 AM


Aspkin Group

All times are GMT -5. The time now is 05:45 AM.


Stop the guessing games and learn how you can quickly and easily get back on eBay today!
Read the best selling step-by-step eBay Suspension guide eBay Stealth!
Amazon Suspension? Read Amazon Ghost to get back on Amazon!
vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Ad Management by RedTyger
no new posts