how do you make a spreadsheet shared in excel

If you want to duplicate multiple sheets, press down the CTRL key and select the sheets you want to copy. Using this Method to Duplicate Multiple Sheets Note: In the Move or Copy dialog box, the drop-down list below ‘ To book’ displays only those workbooks that are currently open. At the end of the workbook’s sheet tab s – For this, from the list below ‘ Before sheet:’ select the ‘ move to end’ option.Before a particular sheet’s tab – For this, from the list below ‘ Before sheet:’, select the sheet before which you want the duplicate sheet to go.If you want the duplicate sheet to go into a new workbook, select the ‘ new book’ option. In a different workbook – For this, select the dropdown list below ‘ To book:’ and select the workbook you want to copy the sheet to.Select where you want the duplicate sheet to go.Make sure the checkbox next to Create a Copy’ is checked.This will open the Move or Copy dialog box.From the drop-down menu that appears, select the ‘Move or Copy Sheet’ option.Click on the Format button (under the Cells group).To make a duplicate of the sheet, follow the steps given below: Let’s say “ Sheet 1” is the currently active sheet. Using the Format Menu to Duplicate a Sheet in Excel For each of the methods, we will use the set of worksheets shown below: Let us look at each of these methods one by one. Making Multiple Duplicates of a Sheet (Using VBA)ģ ways to Duplicate One or Multiple Sheets in Excelįirst, let us look at how you can make duplicates of one or more sheets in Excel.

Using the Worksheet tab Context Menu to Duplicate a Sheet in Excel.Using this Method to Duplicate Multiple Sheets.Using the Format Menu to Duplicate a Sheet in Excel.3 ways to Duplicate One or Multiple Sheets in Excel.

How do you make a spreadsheet shared in excel