Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel training program - copying formulae

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training program - Copying Formulae

excel training program - Copying Formulae

ResolvedVersion Standard

Ian has attended:
Excel Advanced course

Copying Formulae

Hi,


"Copying formulae when referenced cells in range aren't adjacent"


I am trying to drag a formula across a row of adjacent cells however the cells that are referenced in the formula aren't adjacent - there are some hidden cells that are being included that I don't want to include. Example:

=('Sheet1!$L10-'Sheet2'!AB200)*$F$11

If I drag this formula across to the next cell I would get:

=('Sheet1!$L10-'Sheet2'!AC200)*$F$11

When in fact I want to skip 4 hidden columns in between columns AB and AG and return:

=('Sheet1!$L10-'Sheet2'!AG)*$F$11

Any suggestions? I'm not great with macros which I guess is one solution...

Thanks,

Ian

Edited on Tue 1 May 2007, 16:56

RE: Copying Formulae

Hi Ian, thanks for the post, I have been trying to recreate your problem, however having a little bit of a difficulty in getting an example together of the problems you are experiencing, could you please give a little bit more info, I'm almost there with an answer using an exercise of my own, but as I say, need a bit more info. (P.S. I tried using Custom Views, and it nearly worked.)

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.