![](/uploads/1/2/5/8/125855927/441630730.jpg)
Two changes that make it easier to organize and identify worksheets and the data they contain are to rename the worksheet and to change the color of the worksheet tab at the bottom of the work area.
VBA code can be written to copy data from one Excel sheet to another instead of a macro. With a macro, if it is not written correctly, the same sheet will be copied to subsequent new sheets every time the macro is executed.Copying the Excel sheets manually will not be possible if the Excel sheet contained too much data.
These instructions apply to Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2019 for Mac, Excel 2016 for Mac, Excel for Mac 2011, Excel for Office 365, and Excel Online.
Using Keyboard Hotkeys
In Excel 2019, Excel 2016, Excel 2013, or Excel 2010, you can use a keyboard shortcut to rename a worksheet tab.
This set of keystrokes activates the ribbon commands. Once the last key in the sequence, the R, is pressed and released, the current name on the sheet tab of the current or active sheet is highlighted.
- Press and release in sequence the following key combination to highlight the name of the active sheet: Alt + H + O + R.
- Type the new name for the worksheet.
- Press the Enter key on the keyboard to complete renaming the worksheet.
As with renaming a worksheet using hotkeys, you don't have to hold down the Altkey while you press the other keys, as with some keyboard shortcuts. Each key is pressed and released in succession.
Double-Click the Sheet Tab
This method works in all versions of Excel for Windows, Mac, 365, and Online.
- Double-click on the current name in the worksheet tab to highlight the current name in the tab.
- Type the new name for the worksheet.
- Press the Enter key on the keyboard to complete renaming the worksheet.
- The new name should be visible on the worksheet tab.
![How do you copy one excel 2011 for mac sheet to a blank sheet with everything the same time How do you copy one excel 2011 for mac sheet to a blank sheet with everything the same time](/uploads/1/2/5/8/125855927/507916124.png)
Right-Click the Sheet Tab
This method works in all versions of Excel for Windows, Mac, 365, and Online.
- Right-click on the tab of the worksheet you want to rename to open the context menu.
- Click on Rename in the menu list to highlight the current worksheet name.
- Type the new name for the worksheet.
- Press the Enter key on the keyboard to complete renaming the worksheet.
- The new name should be visible on the worksheet tab.
Access the Ribbon Option with the Mouse
This method works in all versions of Excel for Windows, Mac, 365, and Online.
- Click on the tab of the worksheet to be renamed to make it the active sheet.
- Click on the Home tab of the ribbon.
- Click Format in the Cells group to open the drop-down menu.
- Click on Rename Sheet to highlight the sheet tab at the bottom of the screen.
- Type the new name for the worksheet.
- Press the Enter key on the keyboard to complete renaming the worksheet.
View All Sheet Tabs in a Workbook
If a workbook has a lot of worksheets or the horizontal scroll bar is extended, not all the sheet tabs will necessarily be visible at once. The longer the sheet names, the longer the tabs.
- Place the mouse pointer over the vertical ellipsis (three vertical dots) next to the horizontal scrollbar.
- The mouse pointer will change to a double-headed arrow, as shown in the image above.
- Press and hold down the left mouse button and drag the pointer to the right to enlarge the area for sheet tabs to be displayed, or to the left to widen the scrollbar.
Excel Worksheet Name Restrictions
There are a few restrictions when it comes to renaming an Excel worksheet:
- A name cannot exceed 31 characters in length
- A worksheet name cannot be left blank
- The following characters cannot be in a name: / ? : * [ ]
Using Worksheet Names in Excel Formulas
Renaming a worksheet not only makes it easier to keep track of individual sheets in a large workbook, but it has the added benefit of making it easier to understand formulas that span multiple worksheets.
When a formula includes a cell reference from a different worksheet, the worksheet name must be in the formula.
If the default worksheet names are used - such as Sheet2, Sheet3 - the formula will look something like this:
Giving the worksheets a descriptive name - such as May Expenses and June Expenses - can make the formula easier to decipher. For example:
![](/uploads/1/2/5/8/125855927/441630730.jpg)