Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 10th 10, 01:20 PM posted to microsoft.public.excel.newusers
KRK KRK is offline
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2007
Posts: 91
Default 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


  #2   Report Post  
Old July 6th 21, 07:29 AM
Member
 
First recorded activity by ExcelBanter: Jun 2021
Posts: 47
Default 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!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Row height/column width Connie Martin Excel Discussion (Misc queries) 3 June 20th 09 04:12 PM
Screen Width & Height leerem Excel Discussion (Misc queries) 1 May 22nd 09 05:45 PM
Rows & Columns Fixed Width / Height Elgee Excel Discussion (Misc queries) 2 August 22nd 08 10:19 PM
How to create different height rows in different columns ezy Setting up and Configuration of Excel 1 August 17th 07 03:06 AM
cell width and height Brian Brandt New Users to Excel 3 February 14th 06 11:57 AM


All times are GMT +1. The time now is 03:06 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017