Function copy pull-down

C

careysynergy

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

When you write a function in a cell and want to copy that function to a row or column or even just a group of other cells - you can go to the corner of the cell, when the cursor turns to a cross and pull down/copy the function to other cells. A very cool app.
Here's a good one - how come sometimes it changes the target cells of the function?? normally whether down or across - if you pull the cross down/across to paste the function across numerous cells - the exact same "offset target cells" will show up and you end up with "#number" or "0 with alert box" saying it's to an empty cell.
Why does it do that and how to fix???
 
C

CyberTaz

It isn't a matter of what tool you use - any copy method will render the
same results you describe. It's symptomatic of your formula needing to use
Absolute as opposed to Relative cell references so those references don't
change when copied to the other locations. See Excel Help on the subject.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top