software

I am trying to create a running balance, I have selected the fill handle but
it does not seem to fill down. I either get a copy of the contents of that
cell all the way down or I get blank cells. I am using office 2003 but I
think the file I am doing this on may have been created on office 2002.
Could this be the problem or am I doing something wrong?


What are the contents of the cell you're trying to copy? It's possible
that you have an absolute cell reference in there, like $A$1. You
might try changing that to $A1 if you're dragging down.

However, if you're also using a cell reference that shouldn't change,
like
Sheet2!B3, you'll have to make that one absolute: Sheet2!$B$3.

HTH

Bruce--
BruceP
------------------------------------------------------------------------
BruceP's Profile: www.excelforum.com/member.php...oamp;userid=33653
View this thread: www.excelforum.com/showthread...hreadid=536398Toolsgt;Optionsgt;Calculation.

Make sure you are set for quot;automaticquot;.Gord Dibben MS Excel MVP

On Wed, 26 Apr 2006 07:08:02 -0700, Flybyplus
gt; wrote:

gt;I am trying to create a running balance, I have selected the fill handle but
gt;it does not seem to fill down. I either get a copy of the contents of that
gt;cell all the way down or I get blank cells. I am using office 2003 but I
gt;think the file I am doing this on may have been created on office 2002.
gt;Could this be the problem or am I doing something wrong?This solved it! I have spent ages with this and it is such a simple thing!
Thanks very much, you are a star!!

quot;Gord Dibbenquot; wrote:

gt; Toolsgt;Optionsgt;Calculation.
gt;
gt; Make sure you are set for quot;automaticquot;.
gt;
gt;
gt; Gord Dibben MS Excel MVP
gt;
gt; On Wed, 26 Apr 2006 07:08:02 -0700, Flybyplus
gt; gt; wrote:
gt;
gt; gt;I am trying to create a running balance, I have selected the fill handle but
gt; gt;it does not seem to fill down. I either get a copy of the contents of that
gt; gt;cell all the way down or I get blank cells. I am using office 2003 but I
gt; gt;think the file I am doing this on may have been created on office 2002.
gt; gt;Could this be the problem or am I doing something wrong?
gt;
gt;

Not so much a star as someone who has made the same type of quot;simplequot; error.

Thanks for the feedback.Gord

On Thu, 27 Apr 2006 01:29:02 -0700, Flybyplus
gt; wrote:

gt;This solved it! I have spent ages with this and it is such a simple thing!
gt;Thanks very much, you are a star!!
gt;
gt;quot;Gord Dibbenquot; wrote:
gt;
gt;gt; Toolsgt;Optionsgt;Calculation.
gt;gt;
gt;gt; Make sure you are set for quot;automaticquot;.
gt;gt;
gt;gt;
gt;gt; Gord Dibben MS Excel MVP
gt;gt;
gt;gt; On Wed, 26 Apr 2006 07:08:02 -0700, Flybyplus
gt;gt; gt; wrote:
gt;gt;
gt;gt; gt;I am trying to create a running balance, I have selected the fill handle but
gt;gt; gt;it does not seem to fill down. I either get a copy of the contents of that
gt;gt; gt;cell all the way down or I get blank cells. I am using office 2003 but I
gt;gt; gt;think the file I am doing this on may have been created on office 2002.
gt;gt; gt;Could this be the problem or am I doing something wrong?
gt;gt;
gt;gt;

Gord Dibben MS Excel MVP