Finding which cells are making the Row Height "auto-fit" go so big

[ellison]

Hi, I'm tidying up some files to make them look a bit more presentable & sometimes the row height is "huge" due to the "wrap text" and the "auto fit" row height.

Is there a way to find which of the cells is driving the height of the row to be so large?

At the moment, I have to scroll across trying to scan for which one the culprit probably is.......... Not a problem on tiny files like in the example below. But on bigger files, it's taking me ages to do this over and over

(I'd then look at editing the text or the formatting of the cells to make it look a bit more "presentable")

Book2
	A	B
1	1	Finding the
2	2	culprit
3	3	sometimes
4	4	takes me ages to scroll across to as some of the files are huge
5	5
6	6	But luckily here, there
7	7	are only
8	8	10 rows
9	9	and 1 column
10	10	It is Cell B3
Sheet1

Cell Formulas
Range	Formula
A1:A10	A1	=ROW()

Thanks for any help

 

[Fluff]

You could use something like this to find the column number

=LET(a,LEN(A2:M2),INDEX(COLUMN(A2:M2),XMATCH(MAX(a),a)))