माइक्रोसॉफ्ट एक्सेल के कुछ महत्वपूर्ण शॉर्टकट कीज

Files related 

 Ctrl + O

 Open File

 Ctrl + N

 New File

 Ctrl + P

 Print

 Ctrl + S

 Save File

 F12

 Save File As

 Ctrl + F4

 Close File

 Alt + F4

 Close Excel

 Esc

 Exit Dialog

 Ctrl + C

 Copy

 Ctrl + X

 Cut

 Ctrl + V

 Paste

 Ctrl + Z

 Undo

 Ctrl + Y

 Redo

 Ctrl + A

 Select All

 Ctrl + F

 Find

 Ctrl + H

 Replace

 Alt + Tab

 Switch Windows

 Alt + T + O

 Options Menu

 F4

 Repeat Last Action

 Ctrl + F1

 Show / Hide Ribbon Menu

Navigation & Data Selection

Arrow Keys

Move Around

 Ctrl + Arrows

 Jump to Boundary

 Shift + Arrows

 Select Cells

 Shift + Ctrl + Arrows

 Select to Boundary

 Shift + F8

 Select Multiple Areas

Editing Cells

F2

 Edit Cell

 Del

 Delete Cell Contents

 Ctrl + Arrows

 Skip Word(s)

 Ctrl + Shift + Arrows

 Highlight Word(s)

 Alt + Enter

 New Line in Cell

 Ctrl + Enter / Tab / Shift + Tab

 Edit and… Stay in Place / Go Left / Go Right

Rows & Columns

 Ctrl + Spacebar

 Select Column

 Shift + Spacebar

 Select Row

 Ctrl + Shift + +

 Insert Cells / Rows / Columns

 Ctrl + –

 Delete Cells / Rows / Columns

  Right Mouse Button + E

  Insert Cut Cells and Shift Over

 Alt + A + G + G

 Group Rows / Columns

 Shift + Alt + Right

 Group Rows / Columns

 Alt + A + U + U

 Ungroup Rows / Columns

 Shift + Alt + Left

 Ungroup Rows / Columns

 Alt + A + J

 Show Grouped Rows / Columns

 Alt + A + H

 Hide Grouped Rows / Columns

Basic Formatting

Alt + H

 Format Menu

 Ctrl + 1

 Format Dialog

 Ctrl + Alt + V

 Paste Special

 Ctrl + Alt + V + T

 Paste Formats

 Ctrl + Alt + V + V

 Paste Values

 Ctrl + Alt + V + F

 Paste Formulas

 Alt + H + FC

 Font Color

 Alt + H + H

 Fill Color

 Alt + H + B

 Border Options

 Alt + H + A + L / C / R

 Align Left / Center/ Right

 Alt + H + 6

 Increase Indent

 Alt + H + 5

 Decrease Indent

 Alt + H + 0

 Increase Decimal Places

 Alt + H + 9

 Decrease Decimal Places

 Ctrl + B

 Bold

 Ctrl + I

 Italics

 Ctrl + U

 Underline

 Ctrl + 5

 Strikethrough

 Ctrl + Shift + &

 Add Borders

 Ctrl + Shift + –

 Delete Borders

 Shift + Ctrl + ~

 General

 Shift + Ctrl + !

 Number

 Shift + Ctrl + @

 Time

 Shift + Ctrl + #

 Date

 Shift + Ctrl + $

 Currency

 Shift + Ctrl + %

 Percentage

 Shift + Ctrl + ^

 Scientific

 =TEXT(Cell, Format)

 Displays cell using custom format

 Alt + H + O + I

 Auto-Fit Col.

 Alt + H + O + A

 Auto-Fit Row

 
Alt + H + O + W

 
Column Width

 Alt + H + O + H

 Row Height

 Alt + H + L + R

 Conditional Formatting

 Alt + H + T

 Format as Table

Formulas and Calculations

=

 Enter Formula

 F9

 Refresh All

 F4

 Anchor Cell

 Ctrl + F3

 Name Cell

 F5

 Jump to Cell

 Tab

 Use Suggested Name

 Shift + F3

 Enter Built-In Function

 Ctrl + Alt + V + F

 Paste Formulas

 Ctrl + Alt + V + R

 Paste Formats & Formulas

 Ctrl + D

 Copy Down

 Ctrl + R

 Copy Right

 Ctrl + ’

 Copy from Above

 F5, Alt + S + F + X

 Go to Formulas

 F5, Alt + S + O + X

 Go to Constants

 Ctrl + ~

 Show Formulas

Display & Printing

Alt + W + F + F

 Freeze Panes

 Alt + W + Q

 Zoom

 Ctrl + Mouse Scroll Wheel

 Zoom

 Alt + P + S + P

 Page Setup

 Alt + P + R + S

 Set Print Range to Selected Area

 Ctrl + F2

 Print Preview

 Alt + W + I

 Page Break View

 Alt + W + L

 Normal View

 Alt + W + VG

 Toggle Gridlines

Filtering, Sorting & Validating

Alt + A + SS

 Sort Data

 Alt + A + SA

 Sort Ascending

 Alt + A + SD

 Sort Descending

 Ctrl + Shift + L

 Filter Data

 Alt + A + Q

 Advanced Data Filter

 Right Mouse Button + E + V

 Filter by Cell’s Properties

 Alt + A + M

 Remove Duplicates

 Alt + A + V

 Validate Data