Microsoft Excel 
ITTraining@sgul.ac.uk Page 8 St. George’s Information Services 
RENAMING A WORKSHEET 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
By default, Excel names worksheets as Sheet1, 
Sheet2, Sheet3, etc. These names are fine if you 
are not planning to share the workbook, but 
changing these to something more relevant 
makes it much easier to understand the purpose of 
a worksheet. You can also adjust the horizontal 
scroll bar to make room for longer, more 
meaningful worksheet names. 
Try This Yourself: 
Same 
File Continue using the previous 
file with this exercise, or open 
the file E1324 Worksheet 
Techniques_2.xlsx... 
 
Point to the vertical dots 
between the sheet names and 
the horizontal scroll bar, as 
shown 
The pointer will change to a 
double-headed arrow... 
 
Click and drag the bar across 
to the right, to the end of 
column L, then release the 
mouse button 
 
Double-click on Sheet1 (5) to 
select the worksheet tab name  
This will also place it into edit 
mode… 
 
Type Comms
, then press  
 
Repeat steps 3 and 4 to 
rename the other worksheets: 
Sheet1 (4) Admin 
Sheet1 (3) Shop 
Sheet1 (2) IT 
Sheet1 Maintenance 
 
1 
3 
4 
5 
For Your Reference… 
To rename a worksheet: 
1. Double click on the current name on the 
worksheet tab 
2. Type the new name and press   
Handy to Know… 
 You can rename a worksheet by 
right-clicking on the worksheet tab to display 
the shortcut menu and clicking on Rename. 
 A worksheet tab name can contain up to 31 
characters including spaces, but it is better to 
keep it short and succinct.