Thread
:
"$" command will not work in VISTA
View Single Post
#
4
June 3rd, 2010, 05:49 PM posted to microsoft.public.excel.misc
Don Guillett[_2_]
external usenet poster
Posts: 607
"$" command will not work in VISTA
BTW. Vista is an operating system, not an excel version.. And, look in the
help index for ABSOLUTE
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"John" wrote in message
...
Hi
Try it this way =$B$1+$B$2
HTH
John
"sjwillow" wrote in message
...
Hello,
Does anyone know why the "$" command will not work in formulas when
running
VISTA? Does anyone have a solution?
A simple version of my problem is:
=$b1+$b2
When you drag down the formula in a column, it will continue to auto fill
with the next number despite the stop function "$" and will look like:
=$b2+$b3
=$b3+$b4
and so on
Any help would be greatly appreciated.
--
Don Guillett[_2_]
View Public Profile
View message headers
Find all posts by Don Guillett[_2_]
Find all threads started by Don Guillett[_2_]