microsoft excel
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Microsoft Excel

resolvedResolved · Low Priority · Version Standard

replyReply Tue 19 Feb 2008, 16:06Delegate Gemma said...

Gemma has attended:
Excel Introduction course

Microsoft Excel

How do I copy the same formula for more than one cell?

For upcoming training course dates see: Pricing & availability

replyReply Thu 21 Feb 2008, 10:02Trainer Mark said...

RE: Microsoft Excel

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

 

Please browse our web site to find out more about
excel computer course london and other Microsoft training courses.

Excel tip:

Create and delete borders

To put a border around the outside of a selected range, press Ctrl+Shift+&. Use Ctrl+Shift+_ (underscore) to remove any borders from a range.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard