linking formulas

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

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

Linking Formulas

resolvedResolved · Low Priority · Version Standard

Fee has attended:
Excel Intermediate course

Linking Formulas

How can I involve currency rates in linking tables when I have 1 table per month linked to a final (annual) one?

RE: Linking Formulas

Hello Fee,
I hope you enjoyed your Excel training session with us.

In response to your question, I think I need a bit more clarification as to what you are trying to do. Are you pulling currency rates by day? Can you give me a bit more detail?

Regards,
Mara
Microsoft Office Specialist Master Trainer


 

Excel tip:

Hiding Formulae in the Formula Bar

It is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar.

Step 1: Select Format > Cells > Protection.

Step 2: Tick Hidden option. Ensure Locked is ticked

Step 3: Select Tools > Protection > Protect Sheet

(Ensure "Protect worksheet and contents of locked cells" is ticked)


View all Excel hints and tips


Server loaded in 0.08 secs.