Question

how you can create link between different sheets in a single workbook​

Answer 1

Answer:

The first method of creating a hyperlink within one workbook is to use the Hyperlink command. Select a cell where you want to insert a hyperlink. Right-click on the cell and choose the Hyperlink option from the context menu. The Insert Hyperlink dialog window appears on the screen.

Explanation:

hope it helps

make it brainlist

follow me

thank you

Answer 2

Answer:

Combine multiple worksheets into one with Copy Sheets

*Start the Copy Sheets Wizard. On the Excel ribbon, go to the Ablebits tab, Merge group, click Copy Sheets, and choose one of the following options: ...

*Select worksheets and, optionally, ranges to merge. ...

*Choose how to merge sheets.

Explanation:

*Select the Page tab in the Page Setup dialog box.

*Select Fit to under Scaling.

*To fit your document to print on one page, choose 1 page(s) wide by 1 tall in the Fit to boxes. ...

* Press OK at the bottom of the Page Setup dialog box.

I hope this will help you