Shortcuts and Linking Sheets

Hi Paula, Thank you for the post, welcome to the forum. in answer to the first part of your question, you can find all the Excel keyboard shortcuts if you activate the Excel Help feature and in the Search Text box type 'Keyboard Shortcuts' click the Show All link and you will see a list of keyboard commands which you can Print out.
For your second part, follow these steps:
Linking in Excel is fairly user friendly and can be done with the following steps:
Lets consider sheets - Master and Other -
1) Open your "master" spreadsheet.
2) Open one of the "other" sheets. Figure out what cell in this sheet you want linked to the "master" sheet. For example purposes lets choose cell C5.
3) Figure out where you want the cell chosen in step 2 to appear in the "master" spreadsheet. For example purposes I'll say cell A1.
4) Select cell A1 in the "master" spreadsheet.
5) Type an "=" sign. This will begin a new formula in Excel. Without pressing enter, change to the "other" spreadsheet and click cell C5. You will notice the formula bar should now read something similar to the following: ='Otherspreadsheetname'!$C$5
6) Press enter.
7) There should now be a value in cell A1 of the "master" spreadsheet that is linked directly to cell C5 of the "other" spreadsheet. If you change the value of cell C5 in the "other" spreadsheet then it will automatically update in the "master" spreadsheet (as long as both files are open).
I hope that has helped in both cases, if so please click the Resolved link, best regards Pete.