Row Height in Merged Cells | Excel Tips & Tricks | Excel @ Work | The S.I.L.K Route

When we merge cells across columns, there's no default option/setting in Excel for automatically adjusting the row height & you have to use the mouse to drag & adjust the row height as required.
This video shows a trick to adjust the row height just by a click of the mouse when the cells are merged across multiple columns.
This trick will help you save a lot of time when preparing Bill of Quantities (BOQ), Invoices, and in any instance where data is spread across multiple columns.
All in all, helping you Excel @ Work!
DK

[@aldalail]

Genius, it works

[@psibapatro5632]

Thank you so much😊

[@TheSILKRoute]

You're welcome 😊. Please subscribe for more such tips and tricks

[@CobusGrobler]

You genius, such a simple and effective solution, has frustrated me for years. Thank you.

[@TheSILKRoute]

Great to hear. Please subscribe for more such tips and tricks in Excel

[@demirdemirbag3194]

Great! Just what I needed. Kudos!

[@TheSILKRoute]

Glad it helped! Please do subscribe for more such tips and tricks.

[@mikeyimawcw]

Very clever! Thank you.

[@TheSILKRoute]

Thanks a lot.

[@chandrakanthedalkar1078]

सर, बहुत कॉम्प्युटर ऑपरेटर तथा EXCEL पर बहुत दिन काम करते हुये हमारे वैसे को आपने दी हुई आयडिया मालूम नही थी.
आपने दी हुई आयडिया हमारे काम में जरूर रंग लाहेगी.

[@TheSILKRoute]

बहुत बहुत धन्यवाद, चंद्रकांत जी। मैं और अधिक टिप्स और ट्रिक प्रदान करने का प्रयास करूंगा। कृपया अपने मित्रों और सहकर्मियों को चैनल की subscribe करने के लिए कहें। नमस्कार.

[@ArturAGO]

Great! Thanks for the trick! ;)

[@TheSILKRoute]

Happy to help! Subscribe for more great tips.

[@hssnnkim]

Genius!

[@TheSILKRoute]

Thanks. Please subscribe

[@diwakarsawant1296]

Good initiative 👍👍

[@TheSILKRoute]

Thanks Diwakar. Please ask your Vigneshwar family to subscribe and comment on any specific issue they may be facing in their routine works in Excel.

[@santoshm3690]

Good one bava👌👌

[@TheSILKRoute]

Thanks, Bawa. Share with your friends and colleagues also.

[@pavansenglish9859]

👌

[@TheSILKRoute]

Thanks.

[@ismailerylmaz7055]

ı do same thing but is not enough

[@TheSILKRoute]

Well tips generally work. All the best.

[@vemajalaganesh]

Sir, is it possible to adjust the row height for rows not merged without a text in column AA or like that?

[@TheSILKRoute]

For adjusting row height of any row without merged cells, drag the boundary below the row heading until the row is the height that you want. Even better double click on the bottom boundary line of the corresponding row.

[@Adi-pl3cl]

When i am trying doing it, the cell is just showing the formula in column Z not giving the result i.e. the text. I have also changed the format from text to general, still no result, not sure why

[@TheSILKRoute]

I am not able to find a solution in the absence of the Worksbook. Can you can send me the file. My alternate email id for this channel is [e-mail]