Excel Keyboard Shortcuts

Hello, Friends, Online Tech Updates me apka swagat hai. Friends Aaj ki is post me hum apko aise software ke bare me batayenge jiska use mostly hota hai. Aaj ke is digital yug me har work computer par ho rha hai. Friends apne Excel ke baare me suna hoga. Aaj ki iss Post me hum apko Excel & Uske important Shortcut Keys ke baare me batayenge. Excel ek aisa software hai jo M.S. Office me aata hai Iska use Spreadsheet banane me kiya jata hai. Excel ke help se hum bahut sare kaam kar sakte hai. jaise hume koi Attendance sheet banana ho ya Marksheet banani ho. isme bahut sare row & column hote hai jisko hum apne hisab se manage kar sakte hai. Excel me bahut sare cell hote hai jisme hum alag alag data bhar sakte hai.

Pehle ke time me hume bahut saari file banani padti thi jisme kafi time lagta tha but ab excel ke aane se kafi help milti hai or time bhi Bachta hai. Excel aaj har department me use hone wala software hai chahe private sector ho ya government sector. Excel ke dwara hum bahut sare work kar sakte hai Jaise ki hume salary slip banani ho ya koi estimate banana ho or account ke liye bhi ye achcha or easy software hai. Friends Excel ke kuch shortcuts keys hai jiske baare me hum apko details me batayenge.

Friends aajkal har koi shortcuts rasta use karta hai jisse work jaldi complete ho. Apna time bache jisse kam time me kafi work kiya jaye. Excel me hum formula & link karke calculation kar sakte hai.Friends Excel ke kuch shortcut keys hai jiski help se aap apna work jaldi kar sakte hai or kafi time bacha sakte hai.

MOST USEFUL EXCEL SHORTCUT KEYS

F2 = Edit the selected cell
Is Shortcut key se hum selected cell ko edit kar sakte hai.
F5 = Go to a Specific Cell
Is Shortcut key se hum Specific Cell me ja sakte hai.
F7 = Spell Check selected text & document
Is Shortcut Key se hum Selected text or document ke spell ko check kar sakte hai.
F11 = Create Chart
Is Shortcut key se hum chart create kar sakte hai.
Ctrl + Shift + ; = Enter the Current time
Is Shortcut Key se Hum Current time enter kar sakte hai.
Ctrl + ; = Enter the Current Date.
Is Shortcut key se hum Current date enter kar sakte hai.
Alt + Shift + F1 = Insert New Worksheet
Iss Shortcut Key Se Hum New Sheet insert kar sakte hai.
Shift + F3 = Open the Excel Formula Window
Iss Shortcut key Se hum Formula window ko open kar sakte hai.
Shift + F5 = Bring up Search Box
Is Shortcut key se hum search box ko open kar sakte hai.
Ctrl + A = Select all contents of worksheet.
Is Shortcut key se hum worksheet ke all contents ko select kar sakte hai.
Ctrl + B = Bold highlighted Selection text.
Is Shortcut key se hum selected text ko bold highlight kar sakte hai.
Ctrl + I = Italicize highlighted Selection.
Is Shortcut Key Se Hum Selected Text ko Italic Form me Show kar Sakte Hai.
Ctrl + C = Copy Selected Text & contents.
Is Shortcut Key se hum text or contents ko copy kar sakte hai.
Ctrl + V = Paste selected text.
Is Shortcut Key Se hum Selected text ko Paste kar, Sakte Hai.
Ctrl + D = Fill
Is Shortcut key se hum Cell fill kar sakte hai.
Ctrl + K = Insert link.
Is Shortcut Key Se Hum koi bhi link Insert kar Sakte hai.
Ctrl + F = Open find & Replace Option.
Is Shortcut key se hum Find & Replace Search Box me Ja Sakte Hai. Text ko Search & Replace Kar Sakte Hai.
Ctrl + G = Open Go to Options
Is Shortcut key se hum go to option me ja sakte hai.
Ctrl + H = Find and replace options.
Is Shortcut Key se Bhi Kisi bhi option ko Find & Replace Kar Sakte Hai.
Ctrl + U = Underline highlighted selection.
Is Shortcut Key Se Hum Selected Text Ko underline Dikha Sakte Hai.
Ctrl + Y = Underline selected Texts.
Is Shortcut key se hum select texts ko under line kar sakte hai.
Ctrl + 5 = Strikethrough highlighted selection.
Is Shortcut key se hum select text ko strikethrough kar sakte hai.
Ctrl + O = Open the option.
Is Shortcut Key Se Hum Sheet ke Open Box Option me Ja Sakte Hai.
Ctrl + N = Open New Blank Sheet ducument.
Is Shortcut Key se hum New Blank Document ko openKar Sakte Hai.
Ctrl + P = Open the print dialog Box.
Is Shortcut Key Se Hum Print Section me Ja Sakte Hai. Print page Preview & Print Le Sakte Hai.
Ctrl + S = Save
Is Shortcut Key Se Hum Sheet Ko Save Kar Sakte Hai.
Ctrl + Z = Undo the last action.
Is Shortcut Key Se hum Last Text & Picture ko Undo Kar sakte hai yani Dubara la Sakte Hai.
Ctrl + F9 = Minimize Current Window.
Is Shortcut Key se Hum window ko minimize kar sakte hai.
Ctrl + F10 = Maximize currently selected window.
Is Shortcut key se hum select windo ko maximize kar sakte hai.
Ctrl + F6 = Switch between open worksbook & Window.
Is Shortcut Key Se hum workbook or window ko apas me switch kar sakte hai
Ctrl + Page Up & Page Down = Move between Excel Worksheet in the same document.
Is Shortcut key se hum same document me excel worksheet ko move kar sakte hai.
Ctrl + Tab = Move Between two or more Excel Files.
Is Shortcut Key Se hum ek se jayada excel files me move kar sakte hai.
Alt + = = Create formula to some all of above cells.
Is Shortcut key se hum all select cells ko sum formula me create karte hai.
Alt + ‘ = Insert Value of above cell into the current cell.
Is Shortcut Key se hum Current cell me dusre cell ki value insert kar sakte hai.
Ctrl + Shift + ! = Format Number in comma Format.
Is Shortcut Key Se Hum Format number ko Comma ( , ) Format me direct likh sakte hai.
Ctrl + Shift + $ = Format Number in Currency Format.
Is Shortcut key se hum Format Number ko Currency Format me likh sakte hai.
Yani Currency ka symbol laga sakte hai.
Ctrl + Shift + # = Format Number in Date Format.
Is Shortcut key se hum Format Number ko DateFormat me likh sakte hai.
Ctrl + Shift + % = Format Number in Percentage Format.
Is Shortcut key se hum Format Number ko Percentage Format me likh sakte hai.
Ctrl + Shift + ^ = Format Number in Scienctific Format.
Is Shortcut key se hum Format Number ko Scientific Format me likh sakte hai.
Ctrl + Shift + @ = Format Number in Time Format.
Is Shortcut key se hum Format Number ko Time Format me likh sakte hai.
Ctrl + → = Move to next section of text.
Is Shortcut Key se text ke next section me ja sakte hai.
Ctrl + Space = Select entire Colomn.
Is Shortcut Key Se hum entire ( संपूर्ण ) column ko select kar sakte hai.
Shift + Space = Select entire Row.
Is Shortcut Key Se hum entire ( संपूर्ण ) Row ko select kar sakte hai.
Ctrl + W = Close Excel File.

Is Shortcut key se hum Excel file ko Close kar sakte hai.

Friends humne apko most useful MS Excel Shortcut keys ke bare me bataya umeed hai apko ye post achchi lagi hogi or kuch achcha sikhne ko mila hoga.

Thanks for Reading……….

Author: Yahya Khan

1 thought on “Excel Keyboard Shortcuts

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.