The Best Shortcut Keys in Microsoft Excel
by AccountingWeb on
Provided by ExcelTip.com
|Ctrl+C Enter, Ctrl+V Ctrl+X||Copy, Paste, Multiple Paste, Cut|
|Ctrl+F, Ctrl+H||Find, Find&Replace|
|Ctrl+P, Ctrl+S, Ctrl+F4, Alt+F4||Print, Save, Close, Close Excel|
|Ctrl+Arrow||Move to edge of region|
|Ctrl+*||Select current region|
|Ctrl+A||Select all cells|
|Ctrl+Home Ctrl+End||Select A1, Select last cell in used range|
|Ctrl+Shift+End||Select from active cell to last cell in used range.|
|Ctrl+Shift+Home||Select from active cell to A1|
|Ctrl+Page Down Ctrl+Page Up||Move to the next sheet, Move to the previous sheet|
|Ctrl+Tab||Move to next open workbook|
|Ctrl+N||Open new workbook|
|Shift+F11||Insert new worksheet|
|Shift+F3||Paste function window|
|=+FunctionName+Ctrl+A||Insert new function|
|Ctrl+F3, F3||Define name, Paste name|
|Ctrl+Spacebar Shift+Spacebar||Select columns, Select rows|
|Ctrl+1, Ctrl+B, Ctrl+U||Format cells, Bold, Underline|
|Ctrl+; , Ctrl+shift+:||Current date, Current time|
You may like these other stories...
With high school teachers having to vie against all things digital to capture their students’ attention, it’s more important than ever for them to use fun and interactive lessons to bring accounting principles to...
Building complex spreadsheets without lookup formulas, such as VLOOKUP, is akin to putting a screw in the wall with a hammer. It’s possible, but the results aren’t pretty, and most probably won’t maintain...
Read more from Michael Alter here and in the Dollars and Sense archive. The noise about using social media as a means to grow your business has become so constant it almost blends into the background at this point. With...
Upcoming CPE Webinars
BAR is an acronym for: Boundaries, Authority and Role. This simple tool will provide participants with a solid understanding of leadership essentials to improve their performance.
This material is designed to provide a start-to-finish overview of how to plan and complete high-quality small audits efficiently.
In this session Excel expert David H. Ringstrom, CPA shares numerous techniques that you can use to work with charts more efficiently.
Key Accounting and Reporting Issues for Nonprofits No. 1: Overview and Statement of Financial Position
This material focuses on non-profit organizations organization, accounting and reporting.