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!
You should read it
- Instructions for copying or moving Worksheet in Excel 2013
- Tips with spreadsheets (sheet) in Excel
- Complete guide to Excel 2016 (Part 9): Working with multiple spreadsheets
- How to protect spreadsheets in Excel
- Instructions to copy and move Sheet in Excel
- How to open multiple spreadsheets side by side in Excel 2013
- MS Excel 2007 - Lesson 4: Working with data
- 5 source to get macro to automate Excel spreadsheets
- Instructions on how to copy formulas in Excel
- How to use Excel spreadsheets in Microsoft Word
- How to add 'Move to' or 'Copy to' to the Windows 10 context menu
- How to copy and rename files in Linux