CATEGORY: Excel Keyboard Shortcuts , Keyboard Formula Shortcuts VERSIONS: All Microsoft Excel Versions

Experienced Excel users prefer to type formulas directly into a cell, in the formula bar. This is a good technique for skilled users who are familiar with the syntax of formulas (where to place commas and parentheses, the order of arguments, and more). If you are not sure of the syntax of the formula, type = and the name of the function, and then press Ctrl+Shift+A. You will now see the syntax of the function.

Rate this tip 1 2 3 4 5   RATING: 3.33   VIEWS: 27652 Email Tip Print Tip Add to My Tips

READER COMMENTS (view all comments)

No comments have been submitted.

REGISTERED USERS - Click here to post comments GUESTS (Click here to register) Name Comment Title Comments

Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition Positioning: The Battle for Your Mind Business Analysis with Microsoft Excel (2nd Edition) Business Plans For Dummies® Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed) The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve

RELATED MICROSOFT EXCEL TIPS

Create User Forms in Microsoft Excel Using Loops in VBA in Microsoft Excel The Best Shortcut Keys in Microsoft Excel Writing Your First VBA Function in Excel Add Combo Box to a Sheet in Microsoft Excel Formulas to calculate Loan payments in Microsoft Excel Array variables using VBA in Microsoft Excel Create an Amortization Schedule in Microsoft Excel Find duplicates items in combine columns in Microsoft Excel Vlookup Formula – Organizing the Data Table

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books