Excel Shortcut Keys are the keys assigned to specific commands that help you work faster and more efficiently in Microsoft Excel. By using excel shortcut keys, you can avoid using the mouse to select commands, which can save you time and help you work more efficiently.

Excel Shortcut Keys

Shortcut & Description

CTRL + A : Select All Rows and Column

CTRL + B : Bold Formatting

CTRL + C : Copy Selection

CTRL + D : Drag Selection

CTRL + F : Find Data

CTRL + G : Go to Print Area

CTRL + H : Replace Data

CTRL + I : Italic Formatting

CTRL + K : Insert Hyperlink

CTRL + L : Create Table

CTRL + N : New Workbook

CTRL + O : Open any Excel Workbook

CTRL + P : Print Page

CTRL + R : Same Data and Format in Left Cell

CTRL + S : Save Workbook

CTRL + T : Create Table

CTRL + U : Under Liner Words

CTRL + V : Paste Selection

CTRL + W : Close Workbook

CTRL + X : Cut Selection

CTRL + Z : Undo recent activity

DELETE : Remove Cell Contents

ALT + A : Go to the Data Tab

ALT + F : Go to the Info Tab (File ===> Info)

ALT + H : Go to the Home Tab

ALT + M : Go to the Formulas Tab

ALT + N : Go to the Insert Tab

ALT + P : Go to the Page Layout Tab

ALT + R : Go to the Review Tab

ALT + W : Go to the View Tab

ALT + Y : Go to the View Tab

ALT + 4 : Open Page Setup

CTRL + - : Delete Raw or Column

CTRL + + : Insert Raw or Column

CTRL + ` : All Formula show in Whole Sheet

CTRL + 1 : Open Tab Formula Cells > General Format

CTRL + 2 : Un-Bold Formatting

CTRL + 3 : Italic Formatting

CTRL + 4 : Under Liner Words

CTRL + 5 : Strikethrough Formatting

CTRL + 9 : Hide Row

CTRL + 0 : Hide Column

CTRL + SHIFT + 8 : All Data Selection

CTRL + SHIFT + F : Open Tab Formula Cells > Font

CTRL + SHIFT + L : Insert Filter to Selection Cells

CTRL + SHIFT + P : Open Tab Formula Cells > General Format