Скачать или смотреть Excel Shortcuts Quick Reference Guide

Ye guide Excel ke important shortcut keys ka quick reference hai jo aapke kaam ko fast aur easy banati hai. Isme workbook, formatting, general, selection, editing aur navigation ke shortcuts diye gaye hain:

📂 WORKBOOK SHORTCUTS

CTRL+O – Opens a workbook

CTRL+N – Create a new workbook

CTRL+P – Displays the print dialog box

CTRL+S – Save the workbook

CTRL+W – Closes the selected workbook

CTRL+F2 – Displays print view

F9 – Calculates all open workbooks

SHIFT+F9 – Applies currency format with two decimal places

SHIFT+F16 – Displays the Save As box

F12 – Displays the Save As box


🎨 FORMATTING SHORTCUTS

CTRL+SHIFT+~ – Applies general format

CTRL+SHIFT+! – Applies currency format with two decimal places

CTRL+SHIFT+% – Applies percentage format with no decimal places

CTRL+SHIFT+# – Applies date format

CTRL+SHIFT+@ – Applies time format with two decimal places, thousands separator

CTRL+1 – Displays the Format Cells box


⚙️ GENERAL SHORTCUTS

CTRL+` – Toggles values as formulas

SHIFT+F3 – Insert Function dialog box

ALT+M+V – Name manager box

CTRL+SHIFT+U – Expand/collapse formula bar

CTRL+F1 – Displays/hides Ribbon

CTRL+SHIFT+L – Apply/remove filter

ALT+A+Q – Advanced filter


📑 SELECTION SHORTCUTS

CTRL+A – Selects entire worksheet (Press twice)

F8 – Toggles extend mode

SHIFT+SPACEBAR – Selects an entire row


✏️ EDITING SHORTCUTS

CTRL+SHIFT+: – Enters current time

CTRL+; – Enters current date

CTRL+C – Copies selected cells

CTRL+D – Copies topmost cell into cells below

CTRL+K – Insert hyperlink

CTRL+T – Create Table dialog box

CTRL+V – Paste

CTRL+X – Cut

CTRL+ALT+V – Paste Special dialog box

CTRL+Z – Undo last action

CTRL+Y – Redo last action

CTRL+F – Find dialog box

CTRL+H – Replace dialog box

ALT+F11 – Opens Macro dialog box

ALT+F8 – Opens Macro dialog box

ALT+D+P – Opens Pivot Table Wizard

ALT+A+M – Remove duplicates

ALT+ENTER – Text to new line in same cell

ALT+D+L – Data Validation


🧭 NAVIGATION SHORTCUTS

TAB – Move left to right cell

SHIFT+TAB – Move right to left cell

CTRL+G or F5 – Go To dialog box

CTRL+END – Moves to last used cell

CTRL+HOME – Moves to first cell

ALT+PAGE DOWN – Move one screen right

ALT+PAGE UP – Move one screen left

CTRL+PAGE UP – Move to previous worksheet

CTRL+PAGE DOWN – Move to next worksheet

CTRL+Arrow Keys – Move to edge of data region


👉 Ye reference sheet Excel users ke liye ek quick handy guide hai jo unke daily work ko fast aur efficient banati hai.