Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting excel
Often when i double click on the extreme Left hand row, the column hieght
gets adjusted to its contents. However i have found that this does not apply to few of the cells.. For eg. in my case the cells having data in BOLD were not being adjusted to its height(even if content of these cells is having less data limited to 6 words). I have used the word-wrap feature throughout the sheet. i had to manually drag the cell hieght in such cases... I have over 4000 rows filled in my excel sheet. is there any way to adjust the column hieght of the cells automatically by selecting all rows & double clicking it? Alternatively, does anyone have a macro for setting this format? Thanks, Chitra |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting excel
chits
Sounds like a few rows were manually set to a height. These will not autofit until you select them and FormatRowAutofit. Easiest is to just select all rows and FormatRowAutofit. Now the double-click should work for all rows. Gord Dibben Excel MVP On Sat, 24 Dec 2005 00:40:02 -0800, "chits" wrote: Often when i double click on the extreme Left hand row, the column hieght gets adjusted to its contents. However i have found that this does not apply to few of the cells.. For eg. in my case the cells having data in BOLD were not being adjusted to its height(even if content of these cells is having less data limited to 6 words). I have used the word-wrap feature throughout the sheet. i had to manually drag the cell hieght in such cases... I have over 4000 rows filled in my excel sheet. is there any way to adjust the column hieght of the cells automatically by selecting all rows & double clicking it? Alternatively, does anyone have a macro for setting this format? Thanks, Chitra |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting excel
Hi,
i have tried this option. But however this did not work. how do we reset hieght of the cells that were manually set earlier? Even after clicking FormatRowAutofit - the cell content is seen partly hidden..This is only for few cells I am using Microsofy Office Excel 2003 (11.5612.5606) can you suggest me if this is a bug?.. any resolutions for this.. - Chitra "Gord Dibben" wrote: chits Sounds like a few rows were manually set to a height. These will not autofit until you select them and FormatRowAutofit. Easiest is to just select all rows and FormatRowAutofit. Now the double-click should work for all rows. Gord Dibben Excel MVP On Sat, 24 Dec 2005 00:40:02 -0800, "chits" wrote: Often when i double click on the extreme Left hand row, the column hieght gets adjusted to its contents. However i have found that this does not apply to few of the cells.. For eg. in my case the cells having data in BOLD were not being adjusted to its height(even if content of these cells is having less data limited to 6 words). I have used the word-wrap feature throughout the sheet. i had to manually drag the cell hieght in such cases... I have over 4000 rows filled in my excel sheet. is there any way to adjust the column hieght of the cells automatically by selecting all rows & double clicking it? Alternatively, does anyone have a macro for setting this format? Thanks, Chitra |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Lost formatting in Excel | Excel Discussion (Misc queries) | |||
How to get Excel to stop formatting time cells incorrectly | Excel Discussion (Misc queries) | |||
Excel conditional formatting error | Excel Discussion (Misc queries) | |||
Excel could not save all the data and formatting you recently ad.. | Excel Worksheet Functions |