Translate

Computer Aided Operations - Useful Tips


Computer Aided Operations - Examples Important MS Excel Shortcut Keys

-Dr. Lalit Kumar Setia*


The article describes various short-cut keys which can be used to perform the financial operations more efficiently using spread-sheets in a software i.e. MS-Excel.  the latest content usually being asked in Competitive Examinations in English Subject.
It is must to learn excel shortcuts in order to perform fast and effectively at workspace. There are a lot of techniques built on the basis of shortcut keys.

Ctrl+A - Select All

Ctrl+B - Bold

Ctrl+C - Copy

Ctrl+D - Fill Down

Ctrl+F - Find
Ctrl+G - Goto

Ctrl+H - Replace

Ctrl+I - Italic

Ctrl+K - Insert Hyperlink

Ctrl+N - New Workbook

Ctrl+O - Open

Ctrl+P - Print

Ctrl+R - Fill Right

Ctrl+S - Save

Ctrl+U - Underline

Ctrl+V - Paste

Ctrl W - Close

Ctrl+X - Cut

Ctrl+Y - Repeat

Ctrl+Z - Undo

F1 - Help

F2 - Edit

F3 - Paste Name

F4 - Repeat last action

F4 - While typing a formula, switch between absolute/relative refs
F5 - Goto

F6 - Next Pane

F7 - Spell check

F8 - Extend mode

F9 - Recalculate all workbooks

F10 - Activate Menubar

F11 - New Chart

F12 - Save As

Ctrl+: - Insert Current Time

Ctrl+; - Insert Current Date

Ctrl+" - Copy Value from Cell Above

Ctrl+’ - Copy Formula from Cell Above

Shift+F1 - What’s This?

Shift+F2 - Edit cell comment

Shift - Hold down shift for additional functions in Excel’s menu

Shift+F3 - Paste function into formula

Shift+F4 - Find Next

Shift+F5 - Find

Shift+F6 - Previous Pane

Shift+F8 - Add to selection

Shift+F9 - Calculate active worksheet

Shift+F10 - Display shortcut menu

Shift+F11 - New worksheet

Shift+F12 - Save

Ctrl+F3 - Define name

Ctrl+F4 - Close

Ctrl+F5 - XL, Restore window size

Ctrl+F6 - Next workbook window

Shift+Ctrl+F6 - Previous workbook window

Ctrl+F7 - Move window

Ctrl+F8 - Resize window

Ctrl+F9 - Minimize workbook

Ctrl+F10 - Maximize or restore window

Ctrl+F11 - Inset 4.0 Macro sheet

Ctrl+F1 - File Open

Alt+F1 - Insert Chart

Alt+F2 - Save As

Alt+F4 - Exit

Alt+F8 - Macro dialog box

Alt+F11 - Visual Basic Editor
Ctrl+Shift+F3 - Create name by using names of row and column labels
Ctrl+Shift+F6 - Previous Window

Ctrl+Shift+F12 - Print

Alt+Shift+F1 - New worksheet

Alt+Shift+F2 - Save

Alt+= - AutoSum

Alt+’ - Format Style dialog box

Ctrl+` - Toggle Value/Formula display
Ctrl+Shift+~ - General format

Ctrl+Shift+A - Insert argument names into formula
Ctrl+Shift+! - Comma format

Alt+Down arrow - Display AutoComplete list
Ctrl+Shift+@ - Time format

Ctrl+Shift+# - Date format

Ctrl+Shift+$ - Currency format

Ctrl+Shift+% - Percent format

Ctrl+Shift+^ - Exponential format

Ctrl+Shift+& - Place outline border around selected cells

Ctrl+Shift+_ - Remove outline border

Ctrl+Shift+* - Select current region

Ctrl++ - Insert

Ctrl+- - Delete

Ctrl+1 - Format cells dialog box

Ctrl+2 - Bold

Ctrl+3 - Italic

Ctrl+4 - Underline

Ctrl+5 - Strikethrough

Ctrl+6 - Show/Hide objects

Ctrl+7 - Show/Hide Standard toolbar

Ctrl+8 - Toggle Outline symbols

Ctrl+9 - Hide rows

Ctrl+0 - Hide columns

Ctrl+Shift+( - Unhide rows

Ctrl+Shift+) - Unhide columns

Alt or F10 - Activate the menu

Ctrl+Tab - In toolbar: next toolbar

Shift+Ctrl+Tab - In toolbar: previous toolbar

Ctrl+Tab - In a workbook: activate next workbook

Shift+Ctrl+Tab - In a workbook: activate previous workbook

Tab - Next tool

Shift+Tab - Previous tool

Enter - Do the command

Shift+Ctrl+F - Font Drop Down List

Shift+Ctrl+F+F - Font tab of Format Cell Dialog box

Shift+Ctrl+P - Point size Drop Down List


*Copyright © 2018 Dr. Lalit Kumar. All rights reserved.
Next Topic :                                                          Creativity Example - Thinking out of Box

No comments:

Post a Comment

Happy to hear from you. Please give your comments...

Auto_1

Horizontal Responsive1

Popular Posts

LoP_1

Special Offer!

Funny Baba

Free Seminars

Featured post

Dr. Lalit Setia CV

Free Notes

Tips to Grow

Earn Money

Popular Posts

Free Download

Tax Saving

Fun in Life

Labels

Professional Guidance Government Income Tax Tax Deduction at Source General Knowledge Important Questions Income Tax TDS Accounting Deduction Governance Haryana Income Tax Return Latest Questions Competitive Examination Current Affairs Drawing and Disbursing Officer Audit Auditing Covid Financial Financial Management Financial Terminology Goods and Services Tax India Knowledge Lalit Kumar Lalit Kumar Setia Money Skills Tax Planning Virus Accounts Attitude Banking Compliance Currency Economic Problem Employee Facts Free Notes Functions GST Government Accounting Government eMarketplace Incomes Information Interest Omicron Virus Organization Payment Science Scientific Causes Section 80C TDS on GST Tips Tricks Very Important Questions answers Administration Advance Tax Anti-Virus Automatic Back Up Balance Sheet Bitcoin Certificate of TDS Computer Control Corruption Creativity Cryptocurrency DDOs Deductions Deductor Deductors Development Dr. Lalit Kumar Duties EPS Economy Employer English Evaluation Example Expenditure FAQs Finance Financial Accounting Financial Administration Financial Control Frustration GeM General Studies Geography Google HRA Information Technology Investment Life Management Meditation Omicron Performance Planning Positivity Process Procurement Public Public Administration Public Services Purchase Matters Questions on General Studies Resources Resume Saving Services Stress Success System Tax Collection Taxable income Technique Technology Tender Training Trust 26AS 80GG 80GGC AIS Statement ATM Abatement Abbreviations About Dr. Lalit Setia Accountant's Duties Accounting Heads Accounting Standards Accounts Branch Accrual Accumulated Fund Act Action Administrative Admissibility of DA Advance Allowance Almighty Amalgamation Amazon Amount Amrapali Group Android Annual General Meeting Annual Information Statement Anomaly Anti-Corruption Anti-virus Protection Antonyms Appraisal Appreciation Arbitrator Arrears Articles of Association Asset Auctio Audit concerns in procurement Automated Teller Machine Automatic Teller Machine Autorised Capital Average Award Bad Debts Balance of Payments Bankrupt Barter Benchmark Bhagat Prahlad Bid Bikaner Bio-Data Bitcoins Bitcoins Network Block Chain Blood Breathing Bribe Buddha Budget C M Window CV Canada Cards Caring Nature Cash Book Cash Flows Central Bank Chapter Character China Clerks Commitment Common Man Communication Communization Competitive Examinations Computation Computer Virus Computerization Conflict Contacts Contribution of Employees Corona Crime Crude Oil Culture Curriculum Vitae Custody Cyber Cybercrime Data Dearness Allowance Debit and Credit Decision Making Deduction under section 80GG Delay in Service Delhi Department Dera Sacha Sauda Desktop Devices Digital Transformation Double Click Double Entry System Dr. Lalit Setia EPF Earnest Money Deposit Earning Money Economic Growth Electronic Payment System Employment Energy Solutions Environment Evasion Examination Exempt Exemption Exemptions Expenditures Experience Exploitation Facebook Failure Festivals Final Accounts Financial Rules Financial Statements Formula Frauds Games General Generation Gap Goals Google search bar Government Deductor Government Officers Grades of Employees Gurmeet Ram Rahim Singh HRMS HUF Harish Chandra Higher Education Hindu Undivided Family History Home Loan House Building Advance House Property House Rent Allowance How to stay protected Human Resource Management System Humanity IAS Officers IT Skills ITR Importance Income Statement Income Tax Changes Income Tax Refund Income and Expenditure Account Income from Gifts Indirect Cost Innovation Internet Interpersonal Interpretation Inventory Inventory Management Investigation Investments Irregularities Jiomeet App Jokes Kids Labour Laptop Laundering Leadership Leadership Tussle Learn Learn English Learn Excel Shortcuts Learning Ledger Ledgers Liquidity Logical Lokpal Lost Crypto currencies Love MS-Office MS-Word Maldives Mankind Mask Material Mathematics Matters Meaning Measurement Equipment Meerabai Messages Methods Minimum Income Scheme Misuse Mitigation Mobile Monitor Monitoring Morality Motivation Mumbai Lockdown NPS National Highways National Pension National Pension System Nationwide Payment News Non Performing Assets Non-performance Official Life One Liner Questions Outstanding PAN number Pakistan Parents tips Pebbles Penalty Pension Per Day DA Petroleum Phonebook Practices Prevention Prices Prime Minister Private Gain Probability Problem Procedure Protection Publica Publishing Purchase Question Quotation Quotes Rational Decisions Rebate Reforms Register Registration Relationship Rent Paid Reporting Research Retirement Robert Vadra SAP SWOT Analysis Saint Ravi Dass Salaries Saudi Arabia Scam Scientific Searching emails Section 234 (a) Section 234 (b) Section 234 (c) Section 87A Security Security of Bitcoins Self Growth Shortcut Smashwords Social Activists Software Space Speculation Spyware Standard Deduction Standard Deduction on Salaries Standards Statistics Story on Husband and Wife Study Material Sugamya Pustakalaya Superintendent Symbols Symptoms of Omicron Synonyms TA Rules TAN TDS Payment Talent Search Tax Credit Taxation Taxpayers Techniques for fast and efficient work Thought Tips for Students Toddlers Tools of Rulers Tourism Trial Balance Type UCP Uncertainty Unemployment Uniformity Unique Code of Payee United States of America Users Using Asterisk Using Quotes Using Site Using minus Utilization Utilization Certificate Vigilance Bureau Whatsapp Working Capital e-Payments e-filing eMarketplace eProcurement financial procedures gmail immunity innovative solutions pandemic records management red-handed speed vaccine बैंकिग मापने वाले यंत्र राष्ट्रीय राजमार्ग

Happy Moments

Learn and Update

Popular Posts

Auto_1

Horizontal Responsive1