Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Column Auto Sizing
How do I make a column automatically resize to grow as large as the data
input in a cell automatically (not having to use the autofit column format option)? |
#2
|
|||
|
|||
Since Excel 97 column widths expand automatically for numerical entries
unless they have been manually set to some width. Format, Column, AutoFit Selection sets the autofit property back on for columns that have been manually adjusted. Column widths do not expand for text entries. -- Jim Rech Excel MVP "oranskeer" wrote in message ... | How do I make a column automatically resize to grow as large as the data | input in a cell automatically (not having to use the autofit column format | option)? |
#3
|
|||
|
|||
You could use a worksheet_change event if the cell was changing because of your
typing: Rightclick on the worksheet tab that should have this behavior. Select view code and paste this into the code window. Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Target.EntireColumn.AutoFit End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Did you know that you could autofit columns (and rows) by doubleclicking on that vertical bar between the column headings. You can even select all the cells and get all the columns at once with just one double click. oranskeer wrote: How do I make a column automatically resize to grow as large as the data input in a cell automatically (not having to use the autofit column format option)? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Auto Sizing
This code does the trick, but disables 'undo'.
Is there a way to have our cake and eat it too? "Dave Peterson" wrote: You could use a worksheet_change event if the cell was changing because of your typing: Rightclick on the worksheet tab that should have this behavior. Select view code and paste this into the code window. Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Target.EntireColumn.AutoFit End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Did you know that you could autofit columns (and rows) by doubleclicking on that vertical bar between the column headings. You can even select all the cells and get all the columns at once with just one double click. oranskeer wrote: How do I make a column automatically resize to grow as large as the data input in a cell automatically (not having to use the autofit column format option)? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
How do I set up a click "column title" and auto arrange data form. | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |