The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel course london - Formulas

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

excel course london - Formulas

Resolved · Low Priority · Version Standard

ReplyMon 26 Mar 2007, 09:50Delegate Chris said...

Formulas

How do I copy formulas?

For upcoming training course dates see: Pricing & availability

ReplyMon 26 Mar 2007, 11:33Trainer Tracy said...

RE: formulas

Hi Chris,

Thanks for the question

There are a few ways to copy a formula.

1) Once in the active cell containing the formula you can go up to the Edit menu and use the copy and paste options there.
2) Again in the active cell containing the formula you can right click and a shortcut menus appears where you can copy and paste formulas.
3) If you only wanted to copy the formula relatively down one or two rows you can use the Autofill option. In this case you click in the cell containing the formula put your cursor in the bottom right corner where you cursor turns into a black plus sign then drag the formula down.

Hope this helps, any problems or other questions let me know

Tracy

Excel articles

· Should I Use Data Bars, Colour Scales Or Icon Sets In Excel?
· Make A Custom Sort List In Excel
· Want To Create A Presentation In Excel?
· How To Use The Cell Styles Functionality In Excel 2010
· Microsoft Excel 2007

Excel tip:

Make a quick copy of a worksheet

Hold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too.

To make a copy of a worksheet's contents and formats without duplicating range names: (1) Ensure that you have a blank worksheet to paste to. (2) On the sheet to copy, click on the sheet selection square to the left of Column A's heading to select the whole sheet. (2) Copy the whole sheet. (3) Paste to the blank worksheet.

View all Excel hints and tips

This was not covered during the day. How do you do this?

» Forum post: Adding sound

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions