Sunday, September 21, 2014

worksheet function - How can Excel automatically move to highlighted cell

I have been playing around with Gantt chart template and edited some contents. One of the downsides I've noticed is that when I change the date in cell "E4". The cell on the left-hand section will be highlighted but not moved automatically.




When I change the date to 2/2/2017. The date column will be highlighted but I have to manually scroll to that date.



Question: Is there any way that Excel can automatically move the sheet to selected date?



Gantt Chart

No comments:

Post a Comment

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...