Prevent users from scrolling away on your dashboards [dirty little trick]
Dashboards let users get all the information they want in a quick glance. Not if users start using scroll bars and scroll down to cell A64000.
So here is a quick and dirty trick. Assuming your dashboard ends in row 40, select row 41 and go to menu > window > freeze panes. That way you will ensure that the dashboard remains in viewport no matter what.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Advanced Data Validation Techniques in Excel [spreadcheats]||Say thanks with an excel tip »|