Expand Cell depending on content

[FatalLordes]

Hey all

Firstly, I'm using Excel on the Web so I do have limitations (no VBA, no macros).

I've created a report which grabs data from various tables using functions but I have come across an issue when there is text in the table that is larger than what is in my report. I thought the cell would auto resize or wrap depending upon the content it is grabbing but it would seem it can't do that due the cell actually containing a formula. But please correct me if I'm wrong.

For example, my formula in my E23 cell is

=FILTER(Medical!B2:F999,Medical!A2:A999=B3)

And what it does is go to the Medical sheet and look for every line where the unique field matches what is in B3. This is working find BUT what it is not doing is changing the cell dynamics based on the content it goes and grabs. Currently the report is standard one row height and I've set the cell to say wrap, which it is doing, but it doesn't automatically set the cell height based on the content. I have to manually do that each time. Is there a way to make it automatically do this when the cell content changes whenever B3 is set to something different?

For example, picking B3 to match "Fred" may only mean a couple of words in E23 once it has pulled the data. But change B3 to "Barney" and there may be a number of lines in E23 but it doesn't automatically expand out.

So I guess I'm asking how can I FORCE it to auto set the height of cells once an entry is put in B3? I hope this makes sense

 

[Fluff]

Unfortunately, you can't. A cell will not resize simply because the formula has re-calculated.

 

[FatalLordes]

Unfortunately, you can't. A cell will not resize simply because the formula has re-calculated.

Dang, I thought that might be the case but was hoping it wasn't...