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")
Thanks for any help
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