ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Creating a price list,with different row heights (https://www.excelbanter.com/excel-discussion-misc-queries/37235-creating-price-list-different-row-heights.html)

sbellare

Creating a price list,with different row heights
 

I am trying to create a price list for my business. The problem I am
having is that the price lists consist of two columns containing text.
In the first column, the text has been wrapped, thereby increasing the
row height. In the next column, there is less text, therefore leaving a
gap with the text in the above row. How can I make excel have varying
row heights?
Thanks
Sanjay


--
sbellare
------------------------------------------------------------------------
sbellare's Profile: http://www.excelforum.com/member.php...o&userid=25636
View this thread: http://www.excelforum.com/showthread...hreadid=390464


Bryan Hessey


A row is a row, you cannot have different heights for cells within the
same row, (merged cells excluded)


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=390464


JasonCrimmel


I can only suggest to format the alignment on your second row. Try
centering it verticaly. This will align it with the center of the text
beside it.

Right click the column header and select format cells. Choose
Alignment. Under TEXT ALIGNMENT VERTICAL select center.



Jason


--
JasonCrimmel
------------------------------------------------------------------------
JasonCrimmel's Profile: http://www.excelforum.com/member.php...o&userid=25638
View this thread: http://www.excelforum.com/showthread...hreadid=390464



All times are GMT +1. The time now is 12:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com