Prevent users from scrolling away on your dashboards [dirty little trick]
Posted on November 25th, 2008 in Charts and Graphs
, Learn Excel
- 8 comments
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.