Sunday, May 25, 2025

KEYBOARD SHORTCUT KEYS in Excel || POWERFUL Microsoft Excel keyboard shortcuts || EASY Microsoft Excel keyboard shortcuts

KEYBOARD SHORTCUT KEYS in Excel || POWERFUL Microsoft Excel keyboard shortcuts || EASY Microsoft Excel keyboard shortcuts

Here’s a list of useful Microsoft Excel keyboard shortcuts, grouped by category for easier reference. These work in most modern versions of Excel (Windows):

 Basic Shortcuts

Action Shortcut

New workbook Ctrl + N

Open workbook Ctrl + O

Save workbook Ctrl + S

Print Ctrl + P

Undo Ctrl + Z

Redo Ctrl + Y

Copy Ctrl + C

Cut Ctrl + X

Paste Ctrl + V

Select all Ctrl + A

Find Ctrl + F

Replace Ctrl + H

Close workbook Ctrl + W

 Navigation

Action Shortcut

Move to beginning of row Home

Move to beginning of worksheet Ctrl + Home

Move to last cell with data Ctrl + End

Move one screen down/up Page Down / Page Up

Move one worksheet right/left Ctrl + Page Down / Ctrl + Page Up

Move to next cell Tab

Move to previous cell Shift + Tab


 Editing Cells

Action Shortcut

Edit active cell F2

Fill down Ctrl + D

Fill right Ctrl + R

Insert current date Ctrl + ;

Insert current time Ctrl + Shift + ;

Insert new row Ctrl + Shift + +

Delete selected row/column Ctrl + -


 Formatting

Action Shortcut

Bold Ctrl + B

Italic Ctrl + I

Underline Ctrl + U

Open Format Cells dialog Ctrl + 1

Center align Alt + H, A, C

Format as currency Ctrl + Shift + $

Format as percentage Ctrl + Shift + %

Format as number Ctrl + Shift + !


 Formulas

Action Shortcut

Start a formula =

Toggle absolute/relative reference F4 (while editing formula)

Calculate active worksheet F9

Insert function Shift + F3

AutoSum Alt + =


 Table and Cell Selection

Action Shortcut

Select entire row Shift + Space

Select entire column Ctrl + Space

Select current region Ctrl + Shift + *

Extend selection down/up Shift + ↓ / Shift + ↑

Extend selection right/left Shift + → / Shift + ← 

No comments:

Post a Comment