I am trying to create an overview sheet for people who know even less about
Excel than I do. The original data is an extraction from an online tool and
I have created a "pretty" template to display some of this information using
very simple formulae. What I would like to know is as the results of the
formulae differ (i.e. different text block size ranging from 1 number to a
few lines of text) is there a way of auto-resizing the cell height?

I've tried auto-resize and double click, but as the true contents of the
cell is just a one line formula, that's what the row resizes to.

Any chance there is a simple command to solve this?

Thanks.

Manually, you can select the row and do:
Format|Row|autofit

(or just double click on the line between the row numbers (on the line below the
row you're trying to autofit.)

If you want this more automatic, you could have an event macro that runs each
times that worksheet recalculates.

If you want to try that event macro, you can rightclick on the worksheet tab
that should have this behavior. Select view code and paste this in:

Option Explicit
Private Sub Worksheet_Calculate()
Me.Rows.AutoFit
End Sub


You could be more explicit, too, by using a line like:

Me.Rows("1:15").AutoFit

Excel Believer wrote:

I am trying to create an overview sheet for people who know even less about
Excel than I do. The original data is an extraction from an online tool and
I have created a "pretty" template to display some of this information using
very simple formulae. What I would like to know is as the results of the
formulae differ (i.e. different text block size ranging from 1 number to a
few lines of text) is there a way of auto-resizing the cell height?

I've tried auto-resize and double click, but as the true contents of the
cell is just a one line formula, that's what the row resizes to.

Any chance there is a simple command to solve this?

Thanks.

--

Dave Peterson

Hi Dave,

Thanks for the input, but my problem is that if I do Auto fit, it only
recognizes that the cell(s) has a formula which is only 1 line long so if I
do Auto fit, it resizes for 1 line, not the multiple lines of text which are
being pulled from the master database. Does that make sense?

I don't know if it is possible to do anything to fix this besides manually
resizing or pasting the values.

EB

"Dave Peterson" wrote:

Manually, you can select the row and do:
Format|Row|autofit

(or just double click on the line between the row numbers (on the line below the
row you're trying to autofit.)

If you want this more automatic, you could have an event macro that runs each
times that worksheet recalculates.

If you want to try that event macro, you can rightclick on the worksheet tab
that should have this behavior. Select view code and paste this in:

Option Explicit
Private Sub Worksheet_Calculate()
Me.Rows.AutoFit
End Sub


You could be more explicit, too, by using a line like:

Me.Rows("1:15").AutoFit

Excel Believer wrote:

I am trying to create an overview sheet for people who know even less about
Excel than I do. The original data is an extraction from an online tool and
I have created a "pretty" template to display some of this information using
very simple formulae. What I would like to know is as the results of the
formulae differ (i.e. different text block size ranging from 1 number to a
few lines of text) is there a way of auto-resizing the cell height?

I've tried auto-resize and double click, but as the true contents of the
cell is just a one line formula, that's what the row resizes to.

Any chance there is a simple command to solve this?

Thanks.

--

Dave Peterson

Maybe using the second suggestion would work??????

Excel Believer wrote:

Hi Dave,

Thanks for the input, but my problem is that if I do Auto fit, it only
recognizes that the cell(s) has a formula which is only 1 line long so if I
do Auto fit, it resizes for 1 line, not the multiple lines of text which are
being pulled from the master database. Does that make sense?

I don't know if it is possible to do anything to fix this besides manually
resizing or pasting the values.

EB

"Dave Peterson" wrote:

Manually, you can select the row and do:
Format|Row|autofit

(or just double click on the line between the row numbers (on the line below the
row you're trying to autofit.)

If you want this more automatic, you could have an event macro that runs each
times that worksheet recalculates.

If you want to try that event macro, you can rightclick on the worksheet tab
that should have this behavior. Select view code and paste this in:

Option Explicit
Private Sub Worksheet_Calculate()
Me.Rows.AutoFit
End Sub


You could be more explicit, too, by using a line like:

Me.Rows("1:15").AutoFit

Excel Believer wrote:

I am trying to create an overview sheet for people who know even less about
Excel than I do. The original data is an extraction from an online tool and
I have created a "pretty" template to display some of this information using
very simple formulae. What I would like to know is as the results of the
formulae differ (i.e. different text block size ranging from 1 number to a
few lines of text) is there a way of auto-resizing the cell height?

I've tried auto-resize and double click, but as the true contents of the
cell is just a one line formula, that's what the row resizes to.

Any chance there is a simple command to solve this?

Thanks.

--

Dave Peterson


--

Dave Peterson

Hi Dave,

I tried the code as you suggested (the most advanced thing I have ever done
in Excel by far - but very cool!) but the result is exactly the same as
before. It just resizes the rows to 1 line high.

Thanks anyway for your help.

EB

"Dave Peterson" wrote:

Maybe using the second suggestion would work??????

Excel Believer wrote:

Hi Dave,

Thanks for the input, but my problem is that if I do Auto fit, it only
recognizes that the cell(s) has a formula which is only 1 line long so if I
do Auto fit, it resizes for 1 line, not the multiple lines of text which are
being pulled from the master database. Does that make sense?

I don't know if it is possible to do anything to fix this besides manually
resizing or pasting the values.

EB

"Dave Peterson" wrote:

Manually, you can select the row and do:
Format|Row|autofit

(or just double click on the line between the row numbers (on the line below the
row you're trying to autofit.)

If you want this more automatic, you could have an event macro that runs each
times that worksheet recalculates.

If you want to try that event macro, you can rightclick on the worksheet tab
that should have this behavior. Select view code and paste this in:

Option Explicit
Private Sub Worksheet_Calculate()
Me.Rows.AutoFit
End Sub


You could be more explicit, too, by using a line like:

Me.Rows("1:15").AutoFit

Excel Believer wrote:

I am trying to create an overview sheet for people who know even less about
Excel than I do. The original data is an extraction from an online tool and
I have created a "pretty" template to display some of this information using
very simple formulae. What I would like to know is as the results of the
formulae differ (i.e. different text block size ranging from 1 number to a
few lines of text) is there a way of auto-resizing the cell height?

I've tried auto-resize and double click, but as the true contents of the
cell is just a one line formula, that's what the row resizes to.

Any chance there is a simple command to solve this?

Thanks.

--

Dave Peterson


--

Dave Peterson

If your cells to adjust are merged, then you'll need something else. But if
your cells aren't merged, then that code should have worked ok.

Excel Believer wrote:

Hi Dave,

I tried the code as you suggested (the most advanced thing I have ever done
in Excel by far - but very cool!) but the result is exactly the same as
before. It just resizes the rows to 1 line high.

Thanks anyway for your help.

EB

"Dave Peterson" wrote:

Maybe using the second suggestion would work??????

Excel Believer wrote:

Hi Dave,

Thanks for the input, but my problem is that if I do Auto fit, it only
recognizes that the cell(s) has a formula which is only 1 line long so if I
do Auto fit, it resizes for 1 line, not the multiple lines of text which are
being pulled from the master database. Does that make sense?

I don't know if it is possible to do anything to fix this besides manually
resizing or pasting the values.

EB

"Dave Peterson" wrote:

Manually, you can select the row and do:
Format|Row|autofit

(or just double click on the line between the row numbers (on the line below the
row you're trying to autofit.)

If you want this more automatic, you could have an event macro that runs each
times that worksheet recalculates.

If you want to try that event macro, you can rightclick on the worksheet tab
that should have this behavior. Select view code and paste this in:

Option Explicit
Private Sub Worksheet_Calculate()
Me.Rows.AutoFit
End Sub


You could be more explicit, too, by using a line like:

Me.Rows("1:15").AutoFit

Excel Believer wrote:

I am trying to create an overview sheet for people who know even less about
Excel than I do. The original data is an extraction from an online tool and
I have created a "pretty" template to display some of this information using
very simple formulae. What I would like to know is as the results of the
formulae differ (i.e. different text block size ranging from 1 number to a
few lines of text) is there a way of auto-resizing the cell height?

I've tried auto-resize and double click, but as the true contents of the
cell is just a one line formula, that's what the row resizes to.

Any chance there is a simple command to solve this?

Thanks.

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson