How to rename, copy and move spreadsheets in Excel

The following article provides detailed instructions for you to rename, copy and move spreadsheets in Excel.

1. How to rename a worksheet (sheet) in Excel

- Method 1:

+ Double-click the worksheet name -> when the selected worksheet name is entered, enter the new worksheet name:

How to rename, copy and move spreadsheets in Excel Picture 1

+ After entering the name of the worksheet to change, press Enter -> the worksheet name has been changed:

How to rename, copy and move spreadsheets in Excel Picture 2

- Method 2:

+ Right-click the name of the worksheet to be renamed -> Rename:

How to rename, copy and move spreadsheets in Excel Picture 3

+ After selecting Rename enter a new name for the worksheet -> press Enter -> get the results:

How to rename, copy and move spreadsheets in Excel Picture 4

2. Copy the spreadsheet.

Step 1: Right-click the name of the worksheet to copy -> Move or Copy .

How to rename, copy and move spreadsheets in Excel Picture 5

Step 2: The Move or Copy dialog box appears -> select the location to place the worksheet to be copied in the Before sheet section (for example, choose to preorder the employee sheet ) -> select the Create a copy section -> OK :

How to rename, copy and move spreadsheets in Excel Picture 6

- After selecting Sheet DS_NO duplicated staff is located in front of the old sheet and named as shown:

How to rename, copy and move spreadsheets in Excel Picture 7

3. Move the worksheet (sheet).

Step 1: Right-click the name of the worksheet to copy -> Move or Copy .

How to rename, copy and move spreadsheets in Excel Picture 8

Step 2: The Move or Copy dialog box appears -> select the location of the worksheet to be copied in the Before sheet section (for example, choose the last position of the Sheet tab (move to end ) -> OK:

How to rename, copy and move spreadsheets in Excel Picture 9

After clicking OK the new sheet is moved to the bottom of the sheet tab :

How to rename, copy and move spreadsheets in Excel Picture 10

The above is a detailed guide on how to rename, copy and move spreadsheets in Excel.

Good luck!