The Best Shortcut Keys in Microsoft Excel

Provided by

Ctrl+Z Undo
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
Alt+F11 Open VBE
Ctrl+Shift+Enter Array formula
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

Provided by

You may like these other stories...

The following list highlights 10 apps that that may be of interest to you, your clients, or your clients' clients. They were featured during a session of AWEBLive!, the 12-hour CPE marathon, and presented by Gregory L....
I am a recent MS Accounting degree graduate and I am looking into a programming/IT related career. Anyone here have experience or know any accountants that diverted their careers into IT/Programming/System design, etc?...
Event Date: May 29, 2014 In this presentation Excel expert David Ringstrom, CPA brings you up to speed on the Excel feature you should be using, but probably aren't. The Table feature offers the ability to both...

Upcoming CPE Webinars

Apr 24
In this session Excel expert David Ringstrom, CPA introduces you to a powerful but underutilized macro feature in Excel.
Apr 25
This material focuses on the principles of accounting for non-profit organizations' revenues. It will include discussions of revenue recognition for cash and non-cash contributions as well as other revenues commonly received by non-profit organizations.
Apr 30
During the second session of a four-part series on Individual Leadership, the focus will be on time management- a critical success factor for effective leadership. Each person has 24 hours of time to spend each day; the key is making wise investments and knowing what investments yield the greatest return.
May 1
This material focuses on the principles of accounting for non-profit organizations’ expenses. It will include discussions of functional expense categories, accounting for functional expenses and allocations of joint costs.