Some of these are universal across Microsoft Office products (e.g., Word, PowerPoint, etc.) but are still very helpful when using Excel. Here are some shortcuts that you may not be aware of. One of the top Excel tips is getting acquainted with shortcuts. Intuit does not endorse or approve these products and services, or the opinions of these corporations or organizations or individuals. Excel trick 10: Essential shortcut keys and tips. We provide third-party links as a convenience and for informational purposes only. Readers should verify statements before relying on them.
does not warrant that the material contained herein will continue to be accurate nor that it is completely free of errors when published. Accordingly, the information provided should not be relied upon as a substitute for independent research. does not have any responsibility for updating or revising any information presented herein. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Applicable laws may vary by state or locality. Additional information and exceptions may apply. This content is for information purposes only and should not be considered legal, accounting, or tax advice, or a substitute for obtaining such advice specific to your business. Use Excel keyboard shortcut Alt+N+V to quickly create a pivot table. By using pivot tables, you can organize vast volumes of information into an easily digestible spreadsheet. Pivot tables are ultra-useful tricks for Excel that effectively render a precise and multifaceted summary of thousands of rows and columns of unorganized data.
In Mac OS, you may need to add the Fn key for this shortcut to work.