ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   rows & columns height & width (https://www.excelbanter.com/new-users-excel/258499-rows-columns-height-width.html)

KRK March 10th 10 01:20 PM

rows & columns height & width
 
Hello,

Is there a way of forcing the row height and column width to be equal , and
to remain equal, so that all cells are square ?

Thanks

KK


Wilbur Chua July 6th 21 07:29 AM

CTRL A + Resizing cells
 
Hello,

You can just use ctrl A to highlight all the cells, and resize the row or column, depending on how long or wide you want it to be. Also, sometimes the size of the cell will change based on the font or the length of the object or string in a cell. you can now then just select "shrink to fit" for your object or string to fit in the box or cell you put it into.


For more tips on excel and financial models, you can check this out. Hope this helps!


All times are GMT +1. The time now is 02:08 PM.

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