Scribd Logo
Upload

Welcome to Scribd!

  • 487 views

    50 Time-Saving Keyboard Shortcuts in Excel For Windows - V2

    Uploaded by

    Saud Yuja Gomez
    This document lists 50 time-saving keyboard shortcuts in Excel for Windows. Some key shortcuts include Ctrl+W to close a spreadsheet, Ctrl+S to save, Ctrl+C to copy and Ctrl+V to paste. Other shortcuts allow you to navigate worksheets using keys like Ctrl+Arrow, Page Up/Down and Home/End. Additional shortcuts allow formatting cells using keys like Ctrl+1 to open Format Cells and Ctrl+Shift+Percent to apply percentage formatting.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    50 Time-Saving Keyboard Shortcuts in Excel For Windows - V2

    Uploaded by

    Saud Yuja Gomez
    487 views1 page
    This document lists 50 time-saving keyboard shortcuts in Excel for Windows. Some key shortcuts include Ctrl+W to close a spreadsheet, Ctrl+S to save, Ctrl+C to copy and Ctrl+V to paste. Other shortcuts allow you to navigate worksheets using keys like Ctrl+Arrow, Page Up/Down and Home/End. Additional shortcuts allow formatting cells using keys like Ctrl+1 to open Format Cells and Ctrl+Shift+Percent to apply percentage formatting.

    Original Description:

    MANUAL EXCEL

    Original Title

    50 Time-saving Keyboard Shortcuts in Excel for Windows - V2

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document lists 50 time-saving keyboard shortcuts in Excel for Windows. Some key shortcuts include Ctrl+W to close a spreadsheet, Ctrl+S to save, Ctrl+C to copy and Ctrl+V to paste. Other shortcuts allow you to navigate worksheets using keys like Ctrl+Arrow, Page Up/Down and Home/End. Additional shortcuts allow formatting cells using keys like Ctrl+1 to open Format Cells and Ctrl+Shift+Percent to apply percentage formatting.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    487 views1 page

    50 Time-Saving Keyboard Shortcuts in Excel For Windows - V2

    Uploaded by

    Saud Yuja Gomez
    This document lists 50 time-saving keyboard shortcuts in Excel for Windows. Some key shortcuts include Ctrl+W to close a spreadsheet, Ctrl+S to save, Ctrl+C to copy and Ctrl+V to paste. Other shortcuts allow you to navigate worksheets using keys like Ctrl+Arrow, Page Up/Down and Home/End. Additional shortcuts allow formatting cells using keys like Ctrl+1 to open Format Cells and Ctrl+Shift+Percent to apply percentage formatting.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 1

    50 time-saving keyboard

    shortcuts in Excel for Windows


    Frequently used shortcuts
    Close a spreadsheet. Ctrl + W Undo. Ctrl + Z

    Open a spreadsheet. Ctrl + O Cut. Ctrl + X

    Save a spreadsheet. Ctrl + S Delete column. Alt + H,D, then C

    Copy. Ctrl + C Go to Formula tab. Alt + M

    Paste. Ctrl + V Go to Home tab. Alt + H

    Navigate in cells
    Move one cell to the right in a worksheet. Or, Extend the selection of cells to the
    in a protected worksheet, move between Tab last used cell on the worksheet Ctrl + Shift + End
    unlocked cells. (lower-right corner).
    Move to the last cell on a worksheet,
    to the lowest used row of the rightmost Ctrl + End Move one screen up in a worksheet. Page Up
    used column.

    Move to the beginning Page


    Ctrl + Home Move one screen down in a worksheet. Down
    of a worksheet.
    Move to the next sheet in a Page Move one screen to the right in Page
    Ctrl + Down Alt + Down
    workbook. a worksheet.
    Move to the previous sheet Move one screen to the left in a
    Ctrl + Page Up Alt + Page Up
    in a workbook. worksheet.
    Move to the edge of the current Move to the previous cell in a
    Ctrl + Arrow Key Shift + Tab
    data region in a worksheet. worksheet or the previous option
    in a dialog box.
    Format in cells
    Format a cell by opening the Format Edit the active cell and put the insertion
    Ctrl + 1 F2
    Cells dialog box. point at the end of its contents.
    Open the Insert dialog box to
    Add or edit a cell comment. Shift + F2 Ctrl + Shift + Plus (+)
    insert blank cells.
    Display the Create Table Open the Delete dialog box to
    Ctrl + L or Ctrl + T Ctrl + Minus (-)
    dialog box. delete selected cells.
    Enter the current time. Ctrl + Shift + Colon (:) Enter the current date. Ctrl + Semi-colon (;)

    Switch between displaying cell values Grave Open the Paste Special
    Ctrl + accent (`) Ctrl + Alt + V
    or formulas in the worksheet. dialog box.
    Use the Fill Down command to copy the Use the Fill Right command to copy the
    contents and format of the topmost cell Ctrl + D contents and format of the leftmost cell of Ctrl + R
    of a selected range into the cells below. a selected range into the cells to the right.
    Apply the Percentage format Apply the Scientific number Caret
    Ctrl + Shift + Percent (%) Ctrl + Shift + (^)
    with no decimal places. format with two decimal places.
    Apply the Date format with Number Apply the Time format with the At sign
    Ctrl + Shift + sign (#) Ctrl + Shift + (@)
    the day, month, and year. hour and minute, and AM or PM.
    Apply the Number format
    with two decimal places, Exclamation
    Ctrl + Shift + point (!) Create or edit a hyperlink. Ctrl + K
    thousands separator, and
    minus sign (-) for negative values.
    Check spelling in the active worksheet or Display the Quick Analysis options for
    F7 Ctrl + Q
    selected range. selected cells that contain data.

    Make selections and perform actions


    Select the entire Extend the selection of cells
    Ctrl + A or Ctrl + Shift + Spacebar Shift + Arrow Key
    worksheet. by one cell.
    Fill the selected cell range with the
    Start a new line in the same cell. Alt + Enter Ctrl + Enter
    current entry.
    Select an entire column in a worksheet. Ctrl + Spacebar Select an entire row in a worksheet. Shift + Spacebar

    Repeat the last command or action. Ctrl + Y Undo the last action. Ctrl + Z

    For more tips, videos, help, and training, visit

    aka.ms/excelhelpcenter

    You might also like