Home |
Search |
Today's Posts |
#1
|
|||
|
|||
resize row height and column height
Hallo,
I dubble clic on the dividing lines to make automatically the row or colulmn as big as the biggest cell. I have a lot of cells that have to be resized. Is it possible with one clic to resize all the row and columns ? Thx in advance Tom |
#2
|
|||
|
|||
I have allready had the answer
with a macro : activesheet.columns.autofit activesheet.rows.autofit Tom -----Original Message----- Hallo, I dubble clic on the dividing lines to make automatically the row or colulmn as big as the biggest cell. I have a lot of cells that have to be resized. Is it possible with one clic to resize all the row and columns ? Thx in advance Tom . |
#3
|
|||
|
|||
just enlarge your selection : Select all the columns that you want to
resize and double click on the dividing lines Fadi On Thu, 10 Mar 2005 23:40:23 -0800, "Tom" wrote: Hallo, I dubble clic on the dividing lines to make automatically the row or colulmn as big as the biggest cell. I have a lot of cells that have to be resized. Is it possible with one clic to resize all the row and columns ? Thx in advance Tom |
#4
|
|||
|
|||
just enlarge your selection [Fadi Chalouhi]
Adding to Fadi's reply: You can use Ctrl+A to select all cells therefore it is also selecting all columns and all rows. If you have Excel 2003 you might take a look at my page to get Ctrl+A to work properly as long as macros are active. http://www.mvps.org/dmcritchie/excel...x2k.htm#foobar --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
Formula bar height in XL2K3 w/XP | Excel Discussion (Misc queries) | |||
Displaying column width and row height | Excel Worksheet Functions | |||
sorting changes row height | Excel Discussion (Misc queries) | |||
default row height and column widths | New Users to Excel |