Automatically selecting the Display Area

Spooz

New Member
Joined
Oct 4, 2019
Messages
1
I have a long list of stock option strikes, 130 in all. When the stock price moves up or down beyond the number of rows I can see in my display, is there a way to automatically center the display based on a specific cell (at-the-money strike)?
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Watch MrExcel Video

Forum statistics

Threads
1,095,712
Messages
5,446,099
Members
405,379
Latest member
EDGOUG

This Week's Hot Topics

Top