excel

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

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

Excel

resolvedResolved · Low Priority · Version Standard

Chantel has attended:
Excel Intermediate course
Excel Advanced course

Excel

how do we feed data from one sheet to another

RE: excel

Hi Chantel, Thank you for your post, in answer to your question, the most straighforward way of linking data from one sheet to another is to use the equals sign (=) in your destination cell, then navigate to the cell you wish to link to (source), select it and press the enter key. This now ensures that any data in the source cell will be displayed and is available to be used in any formulas or functions from the destination cell. Note any changes made in the source cell will be reflected in the destination. I hope that helps, best regards Pete.


 

Excel tip:

How to Spell Check an Excel 2010 Worksheet

Excel 2010 does not automatically spell check a document. So, here's how to manually spell check a worksheet.

Either select the ''Review'' tab in the Ribbon, go to the ''Proofing'' section and click ''Spelling.'' Or, simply press F7.

View all Excel hints and tips


Server loaded in 0.08 secs.