Add Excel Spreadsheet To Page. Open all workbooks that you will work with. A window will appear on your right with different items integrated select Embed a widget.
Open all workbooks that you will work with. On the Insert tab in the Text group click Header Footer. Go to the menu on the left to select the tab with the sign.
On the worksheet click Click to add header or Click to add footer.
Insert worksheet from other workbooks with Move or Copy command. Active the workbook containing the worksheet that you will copy. In the menu on the left click on Media and then choose Add New and Select Files Using the file browser that has popped up find the Excel spreadsheet you wish to upload. Click the Documents and Lists button on the toolbar and then on the Documents and Lists page click the name of the document library into which you want to upload the spreadsheets.