![]() |
|
#1
|
|||
|
|||
![]() ![]() 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? |
#2
|
|||
|
|||
![]()
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 |
#3
|
|||
|
|||
![]()
amazing. u're a genius, thanks!
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
snoop | Excel | 4 | 03-16-2017 11:47 AM |
![]() |
catflap | Word VBA | 4 | 08-28-2015 03:02 AM |
![]() |
lily | Excel | 9 | 10-23-2014 06:21 AM |
![]() |
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 |