Microsoft Office Forums - View Single Post - How to make filling of series refer to absolute cell?

Thread: How to make filling of series refer to absolute cell?

View Single Post

Old

03-26-2017, 01:24 AM

GIFCoach.com GIFCoach.com is offline

GIFCoach.com is offline

GIFCoach.com uses Windows 10

Windows 10 GIFCoach.com uses Office 2016

GIFCoach.com uses Office 2016

Office 2016

Novice

Join Date: Mar 2017

Posts: 4

GIFCoach.com is on a distinguished road

Default

Hi,

The reason is that the $ sign in '$F4' locks only the column, and not the row. Therefore when you fill or copy down rows, the rows will change.

To prevent this, lock both the column and the row by using $F$4

Reply With Quote