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![Hourglass done :hourglass: ⌛](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/231b.png)
![Hourglass done :hourglass: ⌛](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/231b.png)
![Thumbs down (n) (n)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f44e.png)
![Thumbs down (n) (n)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f44e.png)
(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
![Hourglass done :hourglass: ⌛](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/231b.png)
![Hourglass done :hourglass: ⌛](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/231b.png)
![Hourglass done :hourglass: ⌛](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/231b.png)
![Thumbs down (n) (n)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f44e.png)
![Thumbs down (n) (n)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f44e.png)
(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