Excel Basic Short Keys ?

Excel Basic Short Keys

Ctrl + N → New Workbook
Ctrl + O → Open
Ctrl + W → Close Workbook
Ctrl + F → Find
Ctrl + H → Replace
Ctrl + B → Bold
Ctrl + I → Italic
Ctrl + U → Underline

🔹 Excel Cell & Data Short Keys

F2 → Edit Cell
Ctrl + Enter → Same data in selected cells
Ctrl + ; → Current Date
Ctrl + Shift + ; → Current Time
Alt + Enter → New line in same cell

🔹 Excel Selection Short Keys

Ctrl + Space → Select Column
Shift + Space → Select Row
Ctrl + Shift + Arrow → Select data range
Ctrl + A → Select all data

🔹 Excel Formula Short Keys

= → Formula start
Alt + = → AutoSUM
F4 → Absolute reference ($)
Ctrl + ` → Show formulas

🔹 Excel Sheet Short Keys

Shift + F11 → New Sheet
Ctrl + Page Up → Previous Sheet
Ctrl + Page Down → Next Sheet
Right Click + Rename → Sheet rename

🔹 Excel Formatting Short Keys

Ctrl + 1 → Format Cells
Ctrl + Shift + % → Percentage
Ctrl + Shift + ₹ / $ → Currency
Ctrl + Shift + ! → Number format

🔹 Excel Rows & Columns

Ctrl + + → Insert Row/Column
Ctrl + - → Delete Row/Column
Alt + H + R → Rename Sheet

🔹 Excel Navigation Short Keys

Ctrl + Arrow Key → Data ke end tak jump
Home → Row ke first cell par
Ctrl + Home → A1 cell
Ctrl + End → Last used cell
Page Up / Page Down → Screen scroll

🔹 Excel Editing Short Keys

Delete → Cell clear
Backspace → Cell ke andar delete
Ctrl + D → Fill Down
Ctrl + R → Fill Right
Ctrl + K → Insert Hyperlink
Ctrl + ; → Today’s Date
Ctrl + Shift + : → Current Time

🔹 Excel Copy / Paste Special

Ctrl + C → Copy
Ctrl + Alt + V → Paste Special
Alt + E + S + V → Paste Values
Alt + E + S + F → Paste Formula

🔹 Excel Table & Filter Short Keys

Ctrl + T → Create Table
Ctrl + Shift + L → Apply / Remove Filter
Alt + ↓ (Down Arrow) → Filter dropdown open

🔹 Excel Sorting Short Keys

Alt + A + S + A → Sort A to Z
Alt + A + S + D → Sort Z to A

🔹 Excel Row / Column Size

Alt + H + O + I → AutoFit Column Width
Alt + H + O + A → AutoFit Row Height

🔹 Excel Hide / Unhide

Ctrl + 9 → Hide Row
Ctrl + 0 → Hide Column
Ctrl + Shift + 9 → Unhide Row
Ctrl + Shift + 0 → Unhide Column

🔹 Excel Workbook Management

Ctrl + Tab → Switch Workbook
Ctrl + Shift + Tab → Previous Workbook

🔹 Excel Charts

Alt + F1 → Default Chart (same sheet)
F11 → Chart in new sheet

🔹 Excel Data Validation

Alt + A + V + V → Data Validation

🔹 Excel Freeze Pane

Alt + W + F + F → Freeze Top Row
Alt + W + F + C → Freeze First Column

🔹 Excel Formula Auditing

Ctrl + [ → Precedent cells
Ctrl + ] → Dependent cells
F9 → Calculate selected formula

🔰 BASIC Computer Short Keys (MUST)

Ctrl + C → Copy
Ctrl + V → Paste
Ctrl + X → Cut
Ctrl + Z → Undo
Ctrl + Y → Redo
Ctrl + A → Select All
Ctrl + S → Save
Ctrl + P → Print
Alt + F4 → Close window
Alt + Tab → App change

🔰 BASIC Excel Short Keys (VERY IMPORTANT)

Ctrl + N → New Excel file
Ctrl + O → Open file
Ctrl + W → Close file
Ctrl + S → Save file
F2 → Cell edit
Enter → Next cell
Tab → Right cell
Esc → Cancel

🔰 BASIC Formatting Short Keys

Ctrl + B → Bold
Ctrl + I → Italic
Ctrl + U → Underline
Ctrl + 1 → Format cells
Alt + Enter → Same cell new line

🔰 BASIC Selection Short Keys

Shift + Arrow → Select cells
Ctrl + Space → Select column
Shift + Space → Select row
Ctrl + A → Select all data

🔰 BASIC Row / Column Short Keys

Ctrl + + → Insert row/column
Ctrl + - → Delete row/column
Right Click → Insert / Delete option

🔰 BASIC Date & Time

Ctrl + ; → Today date
Ctrl + Shift + : → Current time

🔰 BASIC Formula Short Keys

= → Formula start
Alt + = → Auto SUM
F4 → $ (absolute reference)

🔰 BASIC Sheet Short Keys

Shift + F11 → New sheet
Ctrl + Page Down → Next sheet
Ctrl + Page Up → Previous sheet

📌 Beginner ke liye GOLDEN TIP

👉 Agar ye 25–30 shortcuts yaad ho gaye na pyaare ❤️
toh Excel ka 70% kaam keyboard se ho jayega 👍

Agar chaho to main:
✅ Only BASIC short keys ka PDF
✅ Class notes style list
✅ Practice questions ke saath shortcuts

Bas bolo, kaunsa chahiye 😊

Bilkul pyaare 😊
Ab aur bhi BASIC + beginner-friendly short keys de raha hoon — jo roz ka kaam me sabse zyada use hote hain 👇
(Simple, yaad rakhne layak)

🔰 BASIC Typing & Editing Short Keys

Backspace → Left side delete
Delete → Right side delete
Ctrl + Backspace → Ek word delete
Ctrl + Delete → Aage ka word delete
Ctrl + Arrow → Word / data jump
Shift + Arrow → Text select

🔰 BASIC Excel Movement Short Keys

Enter → Neeche cell
Shift + Enter → Upar cell
Tab → Right cell
Shift + Tab → Left cell
Arrow Keys → Cell move

🔰 BASIC Excel Data Work

Ctrl + D → Same data copy down
Ctrl + R → Same data copy right
Ctrl + C + Enter → Multiple cells me same data

🔰 BASIC Find & Replace

Ctrl + F → Find word / data
Ctrl + H → Replace word / data

🔰 BASIC Excel Clear Options

Delete → Cell content clear
Alt + H + E + A → Clear all
Alt + H + E + C → Clear content

🔰 BASIC Excel Filter & Sort

Ctrl + Shift + L → Filter on/off
Alt + ↓ → Filter dropdown
Alt + A + S + A → A to Z sort
Alt + A + S + D → Z to A sort

🔰 BASIC Excel Row / Column Size

Double Click (border) → Auto fit
Alt + H + O + I → AutoFit column
Alt + H + O + A → AutoFit row

🔰 BASIC Excel Hide / Unhide

Ctrl + 9 → Hide row
Ctrl + 0 → Hide column
Ctrl + Shift + 9 → Unhide row
Ctrl + Shift + 0 → Unhide column

🔰 BASIC Excel Sheet Management

Right Click + Rename → Sheet rename
Right Click + Move or Copy → Sheet copy

🔰 BASIC Undo Mistakes (VERY IMPORTANT 😄)

Ctrl + Z → Galti undo
Ctrl + Y → Wapas lao

⭐ Beginner Reminder (Yaad Rakho)

👉 Ctrl + C / V / Z / S / F / B
Ye 6 shortcuts seekh liye = 50% kaam fast 🔥

Agar chaho pyaare ❤️ to main:
📘 BASIC Excel shortcut PDF (step-by-step)
🧠 Exam questions + shortcuts
📝 Practice sheet ke saath shortcuts

Bas batao — PDF chahiye ya aur list? 😊

excel short key

Pyaare 😊
Neeche Excel Short Keys (BASIC → IMPORTANT) ekdum simple Hinglish me de raha hoon 👇
(Exam + Daily Work ke liye BEST)

🔰 Excel BASIC Short Keys (Must Learn)

📂 File

Ctrl + N → New Excel file
Ctrl + O → Open file
Ctrl + S → Save file
Ctrl + W → Close file
Ctrl + P → Print

✏️ Editing

F2 → Cell edit
Enter → Neeche cell
Tab → Right cell
Alt + Enter → Same cell new line
Esc → Cancel

📋 Copy / Paste

Ctrl + C → Copy
Ctrl + V → Paste
Ctrl + X → Cut
Ctrl + Alt + V → Paste Special

🎨 Formatting

Ctrl + B → Bold
Ctrl + I → Italic
Ctrl + U → Underline
Ctrl + 1 → Format Cells

📌 Selection

Ctrl + A → Select All
Shift + Arrow → Select cells
Ctrl + Space → Select Column
Shift + Space → Select Row

➕ Formula

= → Formula start
Alt + = → AutoSUM
F4 → Absolute ($)

📅 Date & Time

Ctrl + ; → Today date
Ctrl + Shift + : → Current time

📄 Sheet

Shift + F11 → New sheet
Ctrl + Page Up → Previous sheet
Ctrl + Page Down → Next sheet

🗑️ Row / Column

Ctrl + + → Insert row/column
Ctrl + - → Delete row/column

🔍 Find

Ctrl + F → Find
Ctrl + H → Replace

🔽 Filter

Ctrl + Shift + L → Filter on/off
Alt + ↓ → Filter dropdown

🚀 Fast Navigation

Ctrl + Arrow → Data ke end tak
Ctrl + Home → A1 cell
Ctrl + End → Last used cell

🔄 Undo / Redo

Ctrl + Z → Undo
Ctrl + Y → Redo

🔹 Excel Navigation (Fast Move)

Ctrl + Arrow → Data ke end tak jump
Home → Row ke start par
Ctrl + Home → Cell A1
Ctrl + End → Last used cell
Page Up / Page Down → Screen move

🔹 Excel Fill & Copy

Ctrl + D → Fill Down
Ctrl + R → Fill Right
Ctrl + Enter → Same data multiple cells
Ctrl + C + Ctrl + V → Fast copy paste

🔹 Excel Paste Special (Daily Use)

Ctrl + Alt + V → Paste Special
Alt + E + S + V → Paste Values
Alt + E + S + F → Paste Formula

🔹 Excel Rows & Columns (Advanced)

Ctrl + Shift + + → Insert row/column
Ctrl + Shift + - → Delete row/column
Alt + H + O + I → AutoFit column width
Alt + H + O + A → AutoFit row height

🔹 Excel Hide / Unhide

Ctrl + 9 → Hide Row
Ctrl + 0 → Hide Column
Ctrl + Shift + 9 → Unhide Row
Ctrl + Shift + 0 → Unhide Column

🔹 Excel Table & Filter

Ctrl + T → Convert data to Table
Ctrl + Shift + L → Filter on/off
Alt + ↓ → Filter open

🔹 Excel Sorting

Alt + A + S + A → Sort A to Z
Alt + A + S + D → Sort Z to A

🔹 Excel Sheet Management

Right Click + Rename → Sheet rename
Ctrl + Drag Sheet → Sheet copy
Alt + H + R → Rename sheet

🔹 Excel Charts

Alt + F1 → Chart same sheet
lF11 → Chart new sheet

🔹 Excel Formula Auditing

Ctrl + [ → Formula precedent
Ctrl + ] → Formula dependent
Ctrl + ` → Show formulas
F9 → Formula calculate

🔹 Excel View

Ctrl + Mouse Scroll → Zoom in / out
Alt + W + F + F → Freeze top row
Alt + W + F + C → Freeze first column

⭐ Pro Tip pyaare ❤️

👉 Agar tum Ctrl, Alt, Shift ke combos samajh gaye
toh Excel 90% keyboard se ho jayega 🔥

Agar chaho to main:
📘 Complete Excel Shortcut PDF (Basic → Advanced)
🧠 Shortcut ke saath examples
🎯 Only office-use shortcut list

Bas batao — PDF ya aur list? 😊

Pyaare 😊
Ab Excel ke aur bhi ADVANCED + POWER USER short keys de raha hoon — jo data work, reports, accounts, SEO sheets sab me kaam aate hain 👇

🔹 Excel Select (Power Selection)

Ctrl + Shift + Arrow → Pura data select
Ctrl + A (twice) → Current region select
Shift + Click → Range select

🔹 Excel Insert Special

Ctrl + + → Insert cells / row / column
Ctrl + - → Delete cells / row / column
Alt + I + R → Insert Row
Alt + I + C → Insert Column

🔹 Excel Move / Copy Cells

Shift + Drag → Move cells
Ctrl + Drag → Copy cells
Alt + Shift + Arrow → Column move

🔹 Excel Number Formatting (Instant)

Ctrl + Shift + ! → Number format
Ctrl + Shift + $ → Currency
Ctrl + Shift + % → Percentage
Ctrl + Shift + # → Date
Ctrl + Shift + @ → Time

🔹 Excel Data Validation

Alt + A + V + V → Data Validation
Alt + ↓ → Dropdown open

🔹 Excel Conditional Formatting

Alt + H + L → Conditional Formatting

🔹 Excel Remove Duplicates

Alt + A + M → Remove duplicates

🔹 Excel Text Tools

Alt + A + E → Text to Columns
Ctrl + E → Flash Fill

🔹 Excel Name Box / Range

Ctrl + F3 → Name Manager
Ctrl + Shift + F3 → Create names

🔹 Excel Protection

Ctrl + 1 → Protection tab → Lock / unlock
Alt + R + P + S → Protect sheet
Alt + R + P + W → Protect workbook

🔹 Excel Workbook & Window

Ctrl + Tab → Switch workbook
Ctrl + F6 → Next workbook window
Alt + F8 → Macro list

🔹 Excel Print Setup

Ctrl + P → Print
Alt + P + S + P → Page setup

🔹 Excel Error Checking

Alt + M + V → Evaluate Formula
Alt + M + D → Trace dependents

🔹 Excel Pivot Table (Basic Shortcuts)

Alt + N + V → Insert Pivot Table
Alt + Shift + → → Expand pivot
Alt + Shift + ← → Collapse pivot

✅ Excel Formula Likhne ka Rule

👉 Har formula = (equal sign) se start hota hai

🔹 Simple Formula Examples

➕ Addition (Jod)


=A1+B1

➖ Subtraction (Ghata)


=A1-B1

✖️ Multiplication (Gunaa)


=A1*B1

➗ Division (Bhag)


=A1/B1

🔹 Common Excel Functions (Basic)

🧮 SUM


=SUM(A1:A5)

📊 AVERAGE


=AVERAGE(A1:A5)

🔢 COUNT


=COUNT(A1:A5)

🔤 COUNTA


=COUNTA(A1:A5)

🔽 MIN / 🔼 MAX


=MIN(A1:A5)
=MAX(A1:A5)

🔹 Logical Formula

❓ IF Formula


=IF(A1>=40,"Pass","Fail")

🔹 Percentage Formula


=(A1/B1)*100

🔹 Absolute Reference ($ use)


=A1*$B$1

👉 $ ka matlab cell fix ho gaya

🔹 Formula Copy Trick

Ctrl + D → Formula neeche copy
Ctrl + R → Formula right copy

🔹 Formula Likhne ke Basic Rules

1️⃣ Har formula = se start hota hai
2️⃣ Cell address (A1, B2…) use hota hai
3️⃣ Operators use hote hain:

+ Addition
- Subtraction
* Multiplication
/ Division
% Percentage

🔹 Arithmetic Formula Examples

➕ Total Marks


=A1+B1+C1+D1

or best:


=SUM(A1:D1)

📊 Average Marks


=AVERAGE(A1:D1)

🔢 Percentage


=(B1/A1)*100

🔹 Logical Formula (IF)

Pass / Fail


=IF(A1>=33,"Pass","Fail")

Grade Formula


=IF(A1>=75,"A",IF(A1>=60,"B","C"))

🔹 Conditional Formulas

SUMIF


=SUMIF(A1:A10,"Apple",B1:B10)

COUNTIF


=COUNTIF(A1:A10,"Yes")

AVERAGEIF


=AVERAGEIF(A1:A10,"Pass",B1:B10)

🔹 Text Formula

Name Join (Full Name)


=A1&" "&B1


=CONCAT(A1," ",B1)

Upper / Lower Case


=UPPER(A1)
=LOWER(A1)
=PROPER(A1)

🔹 Date Formula

Today Date


=TODAY()

Current Date & Time


=NOW()

Age Calculate


=DATEDIF(A1,TODAY(),"Y")

🔹 Lookup Formula (Basic)

VLOOKUP


=VLOOKUP(A1,A2:C10,2,FALSE)

🔹 Error Handle Formula


=IFERROR(A1/B1,"Error")

Agar chaho pyaare ❤️ to main:
📝 Practice sheet ke 20 formula questions
📘 Excel formula PDF (Basic → Advanced)
🎯 Job + Interview formulas

Bas bolo — practice ya PDF? 😊

formula sare

Pyaare 😊
Neeche Excel ke IMPORTANT formulas (almost saare main-use wale) category-wise, simple Hinglish me de raha hoon 👇
(Ye list Basic → Advanced cover karti hai)

🔢 1️⃣ Math / Arithmetic Formulas

=SUM(A1:A10) → Total
=AVERAGE(A1:A10) → Average
=MIN(A1:A10) → Minimum
=MAX(A1:A10) → Maximum
=COUNT(A1:A10) → Numbers count
=COUNTA(A1:A10) → Non-blank count
=ROUND(A1,2) → Round off
=ABS(A1) → Absolute value
=MOD(A1,B1) → Remainder

❓ 2️⃣ Logical Formulas

=IF(A1>=33,"Pass","Fail")
=AND(A1>=33,B1>=33)
=OR(A1>=33,B1>=33)
=NOT(A1=0)
=IFERROR(A1/B1,"Error")

📊 3️⃣ Conditional Formulas

=SUMIF(A1:A10,"Apple",B1:B10)
=COUNTIF(A1:A10,"Yes")
=AVERAGEIF(A1:A10,"Pass",B1:B10)
=SUMIFS(C1:C10,A1:A10,"Apple",B1:B10,"Yes")
=COUNTIFS(A1:A10,"Yes",B1:B10,">50")

🔍 4️⃣ Lookup / Reference Formulas

=VLOOKUP(A1,A2:C10,2,FALSE)
=HLOOKUP(A1,A1:D5,2,FALSE)
=XLOOKUP(A1,A:A,B:B)
=INDEX(A1:C10,2,3)
=MATCH(A1,A1:A10,0)

🔤 5️⃣ Text Formulas

=A1&" "&B1 → Join text
=CONCAT(A1,B1)
=LEFT(A1,4)
=RIGHT(A1,2)
=MID(A1,2,5)
=LEN(A1) → Length
=UPPER(A1)
=LOWER(A1)
=PROPER(A1)
=TRIM(A1)

📅 6️⃣ Date & Time Formulas

=TODAY() → Today date
=NOW() → Date & time
=DAY(A1)
=MONTH(A1)
=YEAR(A1)
=DATEDIF(A1,TODAY(),"Y") → Age

📂 7️⃣ Financial Formulas (Basic)

=PMT(rate,nper,loan)
=EMI() (via PMT)
=FV(rate,nper,pmt)
=PV(rate,nper,pmt)

📈 8️⃣ Statistical Formulas

=MEDIAN(A1:A10)
=MODE(A1:A10)
=STDEV(A1:A10)

🧠 9️⃣ Useful Helper Formulas

=ISNUMBER(A1)
=ISTEXT(A1)
=ISBLANK(A1)
=ROW()
=COLUMN()

🔢 1️⃣ Math & Trigonometry (25)

SUM
SUMPRODUCT
PRODUCT
AVERAGE
AVERAGEA
MIN
MAX
COUNT
COUNTA
COUNTBLANK
ROUND
ROUNDUP
ROUNDDOWN
INT
ABS
MOD
POWER
SQRT
CEILING
FLOOR
RAND
RANDBETWEEN
EVEN
ODD
TRUNC

❓ 2️⃣ Logical Functions (10)

IF
IFS
AND
OR
NOT
IFERROR
IFNA
XOR
TRUE
FALSE

📊 3️⃣ Conditional (8)

SUMIF
SUMIFS
COUNTIF
COUNTIFS
AVERAGEIF
AVERAGEIFS
MAXIFS
MINIFS

🔍 4️⃣ Lookup & Reference (15)

VLOOKUP
HLOOKUP
XLOOKUP
LOOKUP
INDEX
MATCH
XMATCH
OFFSET
INDIRECT
CHOOSE
ROW
ROWS
COLUMN
COLUMNS
ADDRESS

🔤 5️⃣ Text Functions (20)

CONCAT
CONCATENATE
TEXTJOIN
LEFT
RIGHT
MID
LEN
TRIM
CLEAN
UPPER
LOWER
PROPER
FIND
SEARCH
REPLACE
SUBSTITUTE
EXACT
TEXT
VALUE
T

📅 6️⃣ Date & Time (15)

TODAY
NOW
DATE
TIME
DAY
MONTH
YEAR
HOUR
MINUTE
SECOND
WEEKDAY
WEEKNUM
EDATE
EOMONTH
DATEDIF

📈 7️⃣ Statistical (10)

MEDIAN
MODE
LARGE
SMALL
RANK
RANK.EQ
PERCENTILE
QUARTILE
STDEV
VAR

💰 8️⃣ Financial (8)

PMT
PV
FV
NPER
RATE
IPMT
PPMT
NPV

🧠 9️⃣ Information / Error Check (9)

ISNUMBER
ISTEXT
ISBLANK
ISERROR
ISNA
TYPE
ERROR.TYPE
NACELL