**FUN** Help with projecting MLB season final standing, etc.

Ok, I'm following the Braves this year and their record to date is 10-1. I want to project the final regular season wins and losses based on each game's outcome. The problem I'm having is 'locking' the 162 cell for formula purposes and 'filling' the column down. Excel moves the next cell down when "CTRL+D" is pressed and I can't figure this one out.
How do I lock the formula so I can fill down?
Attaching what I have down.
It's no biggie. Just having fun with my brother on FB.
Help would be appreciated though.
All the best to you and your sport and team.