Copying formulas Part 2

  • Thread starter Thread starter Randy Vieira
  • Start date Start date
R

Randy Vieira

I have two worksheets open. In one, I can populate a cell with a formula,
set the cell colors, font, and other attributes, and then double click on
the fill cross (little black cross) and it will automatically fill the cells
below it with like formulas, fonts, colors, etc... The other worksheet,
this does not work. Is there a setting I'm overlooking? Neither sheet is
protected or locked. I've gone through the options dialog box back and
forth between the two worksheets, but I may have missed something.

TIA

Randy,
 
Hi Randy

double click will only work if there is data to the left or a total line or
something that tells excel how far to fill down - it will not work
otherwise, you'll have to drag the fill handle down.

hope this helps
Cheers
JulieD
 
Thank you Julie, That did the trick!

Randy,


JulieD said:
Hi Randy

double click will only work if there is data to the left or a total line
or something that tells excel how far to fill down - it will not work
otherwise, you'll have to drag the fill handle down.

hope this helps
Cheers
JulieD
Click to expand...
 
Just went thought this David,
Double clicking the fill handle will replicate the cell as far down as the
column on the left *or* the right is populated.

If both left and right columns are populated, the length of the left takes
precedence.

You *don't* have to be in Column A for the right column to dictate the
length of the "copy down".
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Hi JulieD,
Almost true. BUT, if you are in Column A so there is no column to
the left, Excel will look at the cells to right when double-clicking
on the fill-handle.
http://www.mvps.org/dmcritchie/excel/fillhand.htm#mouse
 
Back
Top