Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-25-2017, 09:19 PM
dylansmith dylansmith is offline How to make filling of series refer to absolute cell? Windows 8 How to make filling of series refer to absolute cell? Office 2013
Optimizer
How to make filling of series refer to absolute cell?
 
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
  #2  
Old 03-26-2017, 01:24 AM
GIFCoach.com GIFCoach.com is offline How to make filling of series refer to absolute cell? Windows 10 How to make filling of series refer to absolute cell? 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
  #3  
Old 03-26-2017, 07:41 AM
dylansmith dylansmith is offline How to make filling of series refer to absolute cell? Windows 8 How to make filling of series refer to absolute cell? Office 2013
Optimizer
How to make filling of series refer to absolute cell?
 
Join Date: Nov 2011
Posts: 144
dylansmith is on a distinguished road
Default

amazing. u're a genius, thanks!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make filling of series refer to absolute cell? filling a row value from another cell snoop Excel 4 03-16-2017 11:47 AM
How to make filling of series refer to absolute cell? Refer to cell in embedded Excel object within word catflap Word VBA 4 08-28-2015 03:02 AM
How to make filling of series refer to absolute cell? If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3) lily Excel 9 10-23-2014 06:21 AM
How to make filling of series refer to absolute cell? Keeping an absolute reference in a cell bremen22 Excel 7 01-16-2014 11:06 AM
How do I align image at ABSOLUTE top left of a table cell? shnoozin Outlook 0 07-22-2011 03:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:44 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft