jan001
Board Regular
- Joined
- Jul 22, 2004
- Messages
- 123
I have a report I produce (Excel 2010) every month for management. It's usually 1200 to 1500 rows. The default height for each row is 32.50 but about 40-50% of the rows need to be "higher" than than to display all the content in certain cells.
If I select Auto-Fit under Home > Cells > Format, that does allow display of all the content in each cell, but it also makes certain rows very narrow if all their content fits that way. Management perceives that as difficult to read even though the font size doesn't change, and prefers a little more "white space".
If I highlight all the rows and use right-click to set the Row Height to 32.50 (the minimum height I've identified as satisfactory), then I've had to go through and manually expand the rows that need more height to display all their contents. It's not hard but it sure is tedious and there other things I'd like to do with my time. 8/
What I'm asking for is apparently a way to use a set row height of 32.50 unless a given row requires more room, in which case auto-fit kicks in. Am I missing a simple way to do this? Thanks in advance, as always.
If I select Auto-Fit under Home > Cells > Format, that does allow display of all the content in each cell, but it also makes certain rows very narrow if all their content fits that way. Management perceives that as difficult to read even though the font size doesn't change, and prefers a little more "white space".
If I highlight all the rows and use right-click to set the Row Height to 32.50 (the minimum height I've identified as satisfactory), then I've had to go through and manually expand the rows that need more height to display all their contents. It's not hard but it sure is tedious and there other things I'd like to do with my time. 8/
What I'm asking for is apparently a way to use a set row height of 32.50 unless a given row requires more room, in which case auto-fit kicks in. Am I missing a simple way to do this? Thanks in advance, as always.
