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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

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

Excel

ResolvedVersion 2003

Wed 1 Oct 2008, 16:45 Delegate Natasha said...

Natasha has attended:
Excel Intermediate course

Excel

if you have the same worksheet open twice and you amend one and save it, when you go back and amend it will it save changes on the other worksheet???

Fri 3 Oct 2008, 16:50 Trainer Amanda said...

RE: Excel

Hello Natasha

Thank you for your question and welcome to the forum.

Are you referring to when you open a file, then open the file again as a read only copy then make changes and save the read only copy; or are you referring to using a shared workbook?

Amanda

Excel tip:

Fill formulae across a sheet

To copy a formula down a spreadsheet where there is data underneath, to the left or to the right of the formula, double-click on the fill handle. The fill handle is the little black cross that appears in the bottom right-hand corner of the formula cell. Unfortunately, no similar facility exists to copy formulae across the sheet.

One reasonably quick way to copy an existing formula across a sheet is to select the formula and the cells on the right to which you want to copy it. Then press Ctrl+R to copy the formula across the selected range, or, if you are menu-minded, use the Edit|Fill|Right command.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Excel

Excel

RE: Excel

Excel articles

Excel tip:

Fill formulae across a sheet