Ripley2453
New Member
- Joined
- Nov 25, 2015
- Messages
- 12
Hello,
I've been reccomended here to ask about a problem that I just can't seem to find the answer for. I've tried searching google and in-fact everywhere and I can't seem to find a way to fix my problem.
Basically I've built a pivot table, and whenever the filters are changed, or the pivot is refreshed the filter rows always seem to resize!
There's about 7 filter rows on the pivot, and when they auto-size they take up almost half the screen! I want them set at around 16 row height, and I want them to stay that size no matter what happens.
I know that you can un-tick the box in pivot table options, to stop columns auto-sizing and that's all fine and dandy. But I cannot seem to find a way to stop ROWS from resizing!
I'd like to think I'm quite advanced at Excel, I use it everyday and it's my job as a Data Analyst. However, it's frustrating me that I can't seem to find a way around this problem.
Please, someone help me!
I'm using Excel 2013.
I'm new here, and I'm not quite sure how to upload a screenshot. But hopefully my description of the problem will suffice!
Any help will be appreciated.
Cheers!
I've been reccomended here to ask about a problem that I just can't seem to find the answer for. I've tried searching google and in-fact everywhere and I can't seem to find a way to fix my problem.
Basically I've built a pivot table, and whenever the filters are changed, or the pivot is refreshed the filter rows always seem to resize!
There's about 7 filter rows on the pivot, and when they auto-size they take up almost half the screen! I want them set at around 16 row height, and I want them to stay that size no matter what happens.
I know that you can un-tick the box in pivot table options, to stop columns auto-sizing and that's all fine and dandy. But I cannot seem to find a way to stop ROWS from resizing!
I'd like to think I'm quite advanced at Excel, I use it everyday and it's my job as a Data Analyst. However, it's frustrating me that I can't seem to find a way around this problem.
Please, someone help me!
I'm using Excel 2013.
I'm new here, and I'm not quite sure how to upload a screenshot. But hopefully my description of the problem will suffice!
Any help will be appreciated.
Cheers!