View Single Post
 
Old 03-25-2017, 09:19 PM
dylansmith dylansmith is offline Windows 8 Office 2013
Optimizer
 
Join Date: Nov 2011
Posts: 144
dylansmith is on a distinguished road
Default How to make filling of series refer to absolute cell?



as per this example. When I use the Fill function, the formula will use (A7+$F4..5...6...7)*1.04 instead of using F4 as absolute reference.

How do I fix this filling error?
Reply With Quote