how do i set up a cell to autoformat to the text inside the cell?
 

I am putting together a template and I need my cells to auto-adjust to the
amount of text being put into them. I will not be the person putting the data
in or pulling the data together, so it is important that the cells autoformat
and adjust to the amount of text being placed in the cell.

how do i set up a cell to autoformat to the text inside the cell?
 

You can monitor changes with a sheet_change event and use the autofit method
to adjust the column size for the column.
--
http://HelpExcel.com




"melanasue" wrote:

I am putting together a template and I need my cells to auto-adjust to the
amount of text being put into them. I will not be the person putting the data
in or pulling the data together, so it is important that the cells autoformat
and adjust to the amount of text being placed in the cell.

how do i set up a cell to autoformat to the text inside the ce
 

this doesn't really help because I don't know what a sheet_change event is or
how to use it. Can you expand on that topic?

"galimi" wrote:

You can monitor changes with a sheet_change event and use the autofit method
to adjust the column size for the column.
--
http://HelpExcel.com




"melanasue" wrote:

I am putting together a template and I need my cells to auto-adjust to the
amount of text being put into them. I will not be the person putting the data
in or pulling the data together, so it is important that the cells autoformat
and adjust to the amount of text being placed in the cell.

how do i set up a cell to autoformat to the text inside the ce
 

I have placed an example at http://HelpExcel.com/examples

The name of the spreadsheet is columnExpansion.xls
--
http://HelpExcel.com




"melanasue" wrote:

this doesn't really help because I don't know what a sheet_change event is or
how to use it. Can you expand on that topic?

"galimi" wrote:

You can monitor changes with a sheet_change event and use the autofit method
to adjust the column size for the column.
--
http://HelpExcel.com




"melanasue" wrote:

I am putting together a template and I need my cells to auto-adjust to the
amount of text being put into them. I will not be the person putting the data
in or pulling the data together, so it is important that the cells autoformat
and adjust to the amount of text being placed in the cell.