How to Change the Row Height

How to Change the Row or Cell Height?

Expert Asked on August 11, 2016 in Excel Templates.
Add Comment
2 Answer(s)

Please follow the below steps to increase the Column width or Row height:

  • Go to View Tab in the ribbon Menu
  • Check on the ‘Headings’ form Show Group  to show the Sheet Row and Column Headings
  •  And Increase increase the required Row Height
  •  You can point your mouse at edge of the column header and drag to increase the Row Height
  •  OR – you can right click on the required Row and set the  row height

Thanks-PNRao!

Keymaster Answered on August 11, 2016.
Add Comment

we can use  it below also  in VBA editor

cells(x,x).rowwidth=40 ,cells(x,x).columnwidth=40

Top Contributor Answered on August 12, 2016.
Add Comment
  • Found this useful?

    Please share using the share button above.

    If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.

    Found the answer useful and wants to credit the user, then vote the answer (vote up).

  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.