rows & columns height & width
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 ?
CTRL A + Resizing cells
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.