Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to disable column autosizing in Excel 2007
In Excel 2007, if you enter a number that is too big too fit in a cell,
it will automatically adjust the column width to allow the number to fit. I don't want that. Anyone know how to disable it manually or via VBA? Thanks, Nick Hebb |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to disable column autosizing in Excel 2007
Nick,
I don't know how to stop this happening. However you could just set the column widths using code and then I don't think they will change (sorry if i'm wrong). However all number values will show as ##### if the width is too small. Sub changecolumnwidths() ActiveSheet.Range("a1:g20").Select Selection.ColumnWidth = 5 End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to disable column autosizing in Excel 2007
Thanks keri. In this case the ##### display is inconsequential. I need
fixed column widths for another purpose. - Nick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable column only sorting in Excel | Setting up and Configuration of Excel | |||
How do I disable the automatic virus scan when loading Excel 2007 | Setting up and Configuration of Excel | |||
Excel 2007: How do I disable the 'Do you wish to save changes to...' when I close an un changed file? | Excel Discussion (Misc queries) | |||
Autosizing labels in Excel 97 | New Users to Excel | |||
Autosizing labels Excel 97 | Excel Discussion (Misc queries) |