ALL EXCELS SHORT CUT


✅ Basic Excel Shortcuts

  • New workbook: Ctrl + N

  • Open workbook: Ctrl + O

  • Save: Ctrl + S

  • Save As: F12

  • Print: Ctrl + P

  • Close workbook: Ctrl + W

  • Undo: Ctrl + Z

  • Redo: Ctrl + Y

  • Cut: Ctrl + X

  • Copy: Ctrl + C

  • Paste: Ctrl + V

  • Paste special: Ctrl + Alt + V

  • Select all: Ctrl + A

  • Find: Ctrl + F

  • Replace: Ctrl + H

🔢 Cell Navigation

  • Move to next cell: Tab

  • Move to previous cell: Shift + Tab

  • Move right/left: Arrow keys

  • Move down/up: Enter / Shift + Enter

  • Move to beginning of row: Home

  • Move to beginning of worksheet: Ctrl + Home

  • Move to last cell with data: Ctrl + End

  • Jump to next section of data: Ctrl + Arrow key

📋 Working with Cells & Data

  • Edit active cell: F2

  • Fill down: Ctrl + D

  • Fill right: Ctrl + R

  • Insert new row: Ctrl + Shift + + (plus)

  • Delete row or column: Ctrl + - (minus)

  • Insert current date: Ctrl + ;

  • Insert current time: Ctrl + Shift + ;

  • Copy value from above: Ctrl + Shift + "

  • Copy formula from above: Ctrl + '

  • AutoSum: Alt + =

🧮 Formulas & Functions

  • Start a formula: =

  • Toggle absolute reference ($): F4 (after selecting a cell in formula)

  • Insert function: Shift + F3

  • Calculate active worksheet: F9

  • Calculate all worksheets: Ctrl + Alt + F9

✂️ Formatting Cells

  • Bold: Ctrl + B

  • Italic: Ctrl + I

  • Underline: Ctrl + U

  • Open Format Cells dialog: Ctrl + 1

  • Format as currency: Ctrl + Shift + $

  • Format as percentage: Ctrl + Shift + %

  • Format as number: Ctrl + Shift + !

  • Center align: Alt + H, A, C

  • Left align: Alt + H, A, L

  • Right align: Alt + H, A, R

📊 Working with Rows, Columns & Sheets

  • Select entire row: Shift + Space

  • Select entire column: Ctrl + Space

  • Hide selected row: Ctrl + 9

  • Hide selected column: Ctrl + 0

  • Unhide row: Ctrl + Shift + 9

  • Unhide column: Ctrl + Shift + 0

  • Insert worksheet: Shift + F11

  • Switch between sheets: Ctrl + Page Up / Page Down

🔍 Viewing & Window Management

  • Zoom in: Ctrl + Mouse wheel up

  • Zoom out: Ctrl + Mouse wheel down

  • Split window: Alt + W, then S

  • Freeze panes: Alt + W, then F, then F

  • New window: Ctrl + N

  • Switch between open Excel files: Ctrl + F6

  • Full screen: Ctrl + Shift + F1

🔒 Data Tools & Protection

  • Open Data Validation: Alt + D + L

  • Remove duplicates: Alt + A + M

  • Protect sheet: Alt + R + P + S

  • Protect workbook: Alt + R + P + W

🎯 Power Moves (Advanced)

  • Create PivotTable: Alt + N + V

  • Refresh PivotTable: Alt + F5

  • Refresh all data: Ctrl + Alt + F5

  • Group selected rows/columns: Alt + Shift + Right Arrow

  • Ungroup: Alt + Shift + Left Arrow

  • Flash Fill: Ctrl + E

  • Open Power Query: Alt + A + P + N

  • Open Go To dialog: Ctrl + G or F5

  • Name a cell or range: Ctrl + F3

  • Open Name Manager: Ctrl + F3


Comments

Post a Comment

Popular posts from this blog

TALLY PRIME DASHBOARD BY MOHIT SIR

Image
1) TALLY SYLLABUS  TALLY SYLLABUS LINKS 2) TALLY PRIME THEORY QUESTIONS TALLY PRIME THEORY QUESTIONS LINK 3) COMPANY CREATION COMPANY CREATIONS 4) LEDGER CREATION LEDGER CREATIONS 5) STOCK ITEMS CREATION STOCK ITEMS CREATION 6) GODOWN CREATION GODOWN CREATION 7) GODOWN TRANSFER  GODOWN TRANSFER 8) OP. BALANCE , PURCHASE PAYMENT , SALES , RECEIPT (BILLING CONCEPT) OP. BALANCE , PURCHASE PAYMENT , SALES , RECEIPT (BILLING CONCEPT) 9) ORDER PROCESSING  OEDER PROCESSING 10) DEBIT NOTE & CREDIT NOTE DEBIT & CREDIT NOTE LINK 11)MULTIPLE PRICE LEVEL MULTIPLE PRICE LEVEL LINK 12)REORDER LEVEL REORDER LEVEL LINK 13)STANDARD RATE STANDARD RATE 14)MANUFACTURING MANUFACTURING LINK 15)BATCH WISE DETAILS BATCH WISE DETAILS LINK 16)BUDGET&CONTROL BUDGET & CONTROL LINK 17)CASH BOOK CASH BOOK LINK 18)BALANCE SHEET , PL & TRADING  BALANCE SHEET, P/L, TRADING A/C 19) PAYROLL PAYROLL LINK 20) POINT OF SALE POINT OF SALES LINK 21) GST THEORY CONCEPT  ...
Read more

BILLING CHAPTER

Image
बिलकुल! Tally में Opening Balance, Purchase, Payment, Sales, और Receipt क्यों और कब करते हैं, इसका संक्षिप्त उत्तर नीचे दिया गया है: 1. Opening Balance (ओपनिंग बैलेंस) 🔹 Hindi : जब आप Tally में नया कंपनी खाता बनाते हैं, तो आपको पहले से मौजूद स्टॉक और लेन-देन का बैलेंस डालना पड़ता है ताकि सही शुरुआत हो सके। 🔹 English : When you create a new company in Tally, you need to enter the existing stock and balances from previous records to start with accurate data. 2. Purchase (खरीद) 🔹 Hindi : Stock को खरीदने के समय, उसे Tally में दर्ज करते हैं ताकि Inventory और Accounts सही रहें। 🔹 English : Purchases are entered to keep track of stock bought and to update inventory and accounts. 3. Payment (भुगतान) 🔹 Hindi : जब आप किसी को पैसे देते हैं , तो Tally में Payment एंटर करते हैं ताकि आपकी liabilities कम हो सकें। 🔹 English : Payment is recorded when you make payments to vendors or creditors, reducing liabilities . 4. Sales (बिक्री) 🔹 Hindi : Sales ट्रांजेक्श...
Read more

HOW TO CREATE STOCK ITEM

Image
  📦 Stock Items Tally में क्यों बनाए जाते हैं? 🔹 Hindi : Tally में Stock Items इसलिए बनाए जाते हैं ताकि हर प्रोडक्ट का सही-सही रिकॉर्ड रखा जा सके — जैसे कि कितनी मात्रा है, क्या रेट है, कितना सेल हुआ, कितना बचा है आदि। इससे इन्वेंटरी कंट्रोल आसान हो जाता है। 🔹 English : Stock Items are created in Tally to track individual products — including quantity, rate, stock-in-hand, sales, and purchase details. It helps in inventory control and reporting . ✅ मुख्य फायदे / Main Benefits : Inventory का रिकॉर्ड — Quantity और Value ट्रैक करना Track quantity & value of each item Sales & Purchase रिपोर्टिंग Generate reports based on item-wise sales/purchase Stock Summary बनाना आसान Easy to create Stock Summary in Tally Batch-wise और Expiry-wise tracking (Optional) Useful for pharma & food industry Q. HOW TO CREATE STOCK ITEM? PAHLE MAIN PAGE ME JANA HAI ----FIR CREATE ME CLICK KARNA HAI  FIR STOCK ITEM ME JAKAR CLICK KARNA HAI  YAHA KUCH EXAM...
Read more