Enter formulae into multiple cells
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

Hints and tips home » Excel hints and tips » Enter formulae into multiple cells

Enter formulae into multiple cells

If a formula is to be used in a series of cells, select the cells first. Now type in your formula and hold the Ctrl key while you press Enter. This enters the formula in each selected cell.

Just be careful with your absolute and relative cell references.


Added by Martin on 10th October 2011

More Excel hints and tips, like:



Management Training courses London
Course rating:
4.6 stars - based on 70 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Facebook · Twitter · Google+ · LinkedIn · Pinterest