KEMBAR78
Excel Shortcut Keys Advanced | PDF
Scribd
Upload
7 views2 pages

Excel Shortcut Keys Advanced

This document provides a comprehensive list of Excel shortcut keys ranging from basic to advanced functions. It includes commands for copying, cutting, pasting, formatting, and navigating within Excel. The shortcuts enhance productivity by allowing users to perform tasks quickly without relying on mouse actions.

Uploaded by

muruganaachri
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
7 views2 pages

Excel Shortcut Keys Advanced

This document provides a comprehensive list of Excel shortcut keys ranging from basic to advanced functions. It includes commands for copying, cutting, pasting, formatting, and navigating within Excel. The shortcuts enhance productivity by allowing users to perform tasks quickly without relying on mouse actions.

Uploaded by

muruganaachri
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Excel Shortcut Keys - Basic to Advanced

Ctrl + C Copy

Ctrl + X Cut

Ctrl + V Paste

Ctrl + Z Undo

Ctrl + Y Redo

Ctrl + S Save

Ctrl + P Print

Ctrl + F Find

Ctrl + H Replace

Ctrl + A Select All

Ctrl + B Bold

Ctrl + I Italic

Ctrl + U Underline

Ctrl + N New Workbook

Ctrl + O Open Workbook

Ctrl + W Close Workbook

Ctrl + Arrow Key Move to edge of data region

Shift + Space Select entire row

Ctrl + Space Select entire column

Alt + Enter Start a new line within a cell

F2 Edit active cell

F4 Repeat last action

Ctrl + Shift + L Add or remove filters

Ctrl + T Create a table


Ctrl + Shift + + Insert new row or column

Ctrl + - Delete row or column

Alt + E + S + V Paste Special (Values)

Alt + E + S + F Paste Special (Formulas)

Alt + E + S + T Paste Special (Formats)

Alt + H + O + I AutoFit Column Width

Ctrl + Shift + $ Apply currency format

Ctrl + Shift + % Apply percentage format

Ctrl + Shift + # Apply date format

Ctrl + ; Insert current date

Ctrl + Shift + : Insert current time

Alt + = AutoSum

Ctrl + ` Show formulas

Ctrl + Shift + L Toggle filters

Ctrl + F3 Open Name Manager

F3 Paste a defined name into a formula

Alt + F1 Create a chart from the selected data

F11 Create a chart on a new sheet

Ctrl + Arrow Key Jump to edge of data region

Ctrl + Shift + Arrow Key Select to edge of data region

Ctrl + Page Up/Page Down Switch between worksheets

Alt + A + M Remove duplicates

Alt + H + D + C Delete column

Alt + H + D + R Delete row

Alt + H + I + R Insert row

Alt + H + I + C Insert column

You might also like