Shorcut

  • Thread starter Thread starter John Bixtis
  • Start date Start date
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
 
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).
 
John

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

See help on "shortcuts"

Gord Dibben Excel MVP
 
Back
Top