formula

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formula

Formula

resolvedResolved · Medium Priority · Version 2010

Lydia has attended:
Excel Introduction course

Formula

I'd like to know if there is a way to copy a formula down vertically, but using the data running horizontally.

RE: Formula

Hello Lydia,

When you copy a formula, the row reference automatically changes when you copy down a column whereas the column reference changes when you copy across a row.

The results of the calculations are usually positioned at the bottom of the column of data being calculated or at the end of the row.

To place your formulas elsewhere on the sheet could be very confusing but if you really have a need to do this, you will need to edit your formulas after copying them, to get them to process the correct information.

Kind regards,

Ruth

RE: Formula

Hi Ruth,

So is the answer to my question essentially 'no' then?!

To clarify, what I'd want to happen would be to copy a formula down a column, but rather than it following as, for example =E1, =E2, =E3, =E4, it would follow =E1, =F1, =G1, =H1 etc

RE: Formula

Hello Lydia,

The answer IS no. What you want to happen is not what WILL happen when you copy a formula down a column.

Also, normally a formula would include a range not just a single cell bt it does depend on what you are trying to do.

Kind regards,

Ruth

Fri 16 Sep 2011: Automatically marked as resolved.


 

Excel tip:

Adding up time greater than 24 hours

When you add up time if it exceeds 24 hours i.e 27 hours appears as 03:00. Go to Format / Cells / Number / Custom. The format is hh:mm but if change it to [hh]:mm it will add up to the correct amount of hours.

View all Excel hints and tips


Server loaded in 0.08 secs.