Shorcut

J

John Bixtis

Hi,

Does anybody know the shortcut for renaming sheets?
I mean to change the name of the tab at the bottom of the screen, (Sheet1,
Sheet2, etc), without using the mouse.


Thanks.
John
 
D

Don Guillett

It's amazing what you can find in HELP when you look
Work with worksheets

SHIFT+F11 or ALT+SHIFT+F1
Insert a new worksheet.
CTRL+PAGE DOWN
Move to the next sheet in the workbook.
CTRL+PAGE UP
Move to the previous sheet in the workbook.
SHIFT+CTRL+PAGE DOWN
Select the current and next sheet. To cancel selection of multiple sheets,
press CTRL+PAGE DOWN or, to select a different sheet, press CTRL+PAGE UP.
SHIFT+CTRL+PAGE UP
Select the current and previous sheet.
ALT+O H R
Rename the current sheet (Format menu, Sheet submenu, Rename command).
ALT+E M
Move or copy the current sheet (Edit menu, Move or Copy Sheet command).
ALT+E L
Delete the current sheet (Edit menu, Delete Sheet command).
 
G

Gord Dibben

John

ALT+O H R
Rename the current sheet (Format menu, Sheet submenu, Rename command).

See help on "shortcuts"

Gord Dibben Excel MVP
 
Top