cell referencing

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

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

Cell referencing

resolvedResolved · Low Priority · Version 2003

Barry has attended:
Excel Introduction course

Cell referencing

How do I use a cell reference from a different sheet

RE: cell referencing

Hi Barry,

Thank you for your question.

Click into the cell where the formula will be and click =.

Switch to the other sheet and select the cell required, then add the required operator (multiply, addition, subtract or divide).

Then switch back to the sheet where the formula was created and continue to add the cell from that sheet and press enter to end the formula.

I hope this answers your question.

Regards

Simon

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Viewing two Excel 2010 Workbooks at the same time

Did you know you can view two Excel 2010 workbooks side by side? Very useful when comparing data without constantly having to go back and forth!

1) Open both Excel workbooks
2) Select Window then select Compare Side by Side with (Spreadsheet 2)
3) When you have finished, select Window again and click Close Side by Side

View all Excel hints and tips


Server loaded in 0.09 secs.