Announcement

Collapse
No announcement yet.

Shortcut key to delete & rename a worksheet

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Shortcut key to delete & rename a worksheet

    Hi there,
    I'd like to know the shortcut keys for deleting and renaming a worksheet.

    Thanks in advance

  • #2
    Hi msn_manju

    Welcome to ozgrid.com


    See the list below is for working with Worksheets. To get all keyboard shortcuts enter Keyboard shortcuts into the Excel help.

    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).

    Comment

    Working...
    X