The Best Shortcut Keys in Microsoft Excel
by AccountingWeb on
|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...
On January 30, I led a free, one-hour webinar, High Impact Excel: Pivot Table Edition. If you missed the presentation, it’s too late to get CPE credit, but you can watch an on-demand recording. After the webinar, I...
By David Ringstrom, CPA In Part 1 of this series I showed how to use a custom number format to conditionally display decimal places. Although the technique is simple, the downside is it may not work in every situation....
By David Ringstrom, CPA It's pretty much impossible to use Excel and not notice the Name Box, which appears just above the upper-left-hand corner of the worksheet frame. Most users know this as the space in Excel...
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.