Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Microsoft Excel
Resolved · Low Priority · Version Standard
Gemma has attended:
Excel Introduction course
How do I copy the same formula for more than one cell?
Hello Gemma
there are a few ways to copy over formula to other cells you can simply use copy and paste in various ways either through the edit menu, the toolbar buttons or keyboard shortcuts these would be control and X to cut, control and C to copy or control and V to paste
the easiest way to copy the formulas is to use the fill handle and how to do this is as follows
using the cell you want to copy there is a black square at the bottom righthand corner of the cell when you move your cursur there it will become a small black cross, you then click and drag it either over or down
Hope this will help you
Mark East
|
Excel tip:Change the Print button so it brings up the Print dialogue boxIf you want to bring up the Print dialogue box to check your print settings when you hit the Print button, do the following: |
We'll call during UK business hours
Server loaded in 0.09 secs.