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...
While reputational risk is the No. 1 nonfinancial concern among corporate directors, cybersecurity/IT risk is gaining steam. In fact, both private companies and organizations with more than $1 billion in revenue felt they...
Accountants who specialize in forensic and valuation services point to electronic data analysis, or big data, as the most pressing issue they’ll face in the coming months, according to results of a new survey released...
As complex as federal tax can get, at least you're only dealing with one agency: the IRS. But when you get into state and local sales tax, you're coordinating hundreds of jurisdictions that are constantly changing....
Upcoming CPE Webinars
In this session Excel expert David Ringstrom helps beginners get up to speed in Microsoft Excel. However, even experienced Excel users will learn some new tricks, particularly when David discusses under-utilized aspects of Excel.
FRF for SMEs Series--Measurement and Disclosure Principles for various Consolidations and Business Combinations, Part 4B
This webcast will focus on accounting and disclosure policies for various types of consolidations and business combinations.
In this session we'll review best practices for how to generate interest in your firm’s services.