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

copying complex formula

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

Copying Complex Formula

ResolvedVersion 2010

Alice has attended:
Excel Intermediate course

Copying Complex Formula

Hi,

I need to copy a whole line with various functions and formulas into a number of rows. How do I do this and keep the formula the same?

I cant seem to make it work?!

Thanks,

Alice

RE: Copying Complex Formula

Hi Alice,

Thank you for your question.

By the sounds of it, you might need to 'lock' some or all the cell references inside some of all of the formulas, with $ symbols before copying them. It will help me more if I could see the spreadsheet. You're welcome to email me a copy or extract of the spreadsheet, then I can have a better understanding.

You can email it to forum@stl-training.co.uk

Kind regards
Marius
Best STL

Excel tip:

Separate the year from a date

To separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1)

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.1 secs.