» The Best Shortcut Keys in Microsoft Excel
CATEGORY - Excel Keyboard Shortcuts
VERSION - All Microsoft Excel Versions
| 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 |
Book Store:
Recommended Books:
- Word 2002: The Complete Reference
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- Financial Statement Analysis with S&P insert card
- How to Read A Financial Report
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
Copy, Paste, Multiple Paste, Cut code confusing
Jill Posted on: 31-12-1969
The "Copy, Paste, Multiple Paste, Cut" shortcuts are confusing. "Ctrl+C Enter, Ctrl+V Ctrl+X" are listed, but that's only three shortcuts, not four, and Ctrl-C (not Ctrl-C Enter) is Copy.From range of relative references to absolute references
Brian Kelly Posted on: 31-12-1969
I have a range of formulas linking to another sheet, the cells are linked with relative references (A1). I want to select the range of formulas and change all of the cell references to be absolute ($A$1). I dont want to have to click on each cell to change manually using the F4 key - how can I change the cell reference for the entire range of formula from being relative to absolute in one go??
wanna know
santosh Posted on: 31-12-1969
i wanna know what is the short cut for fill color and
what is formula to delete row or colum
formula
mohamedali Posted on: 31-12-1969
anybody know all list of formulas can using in excel?Reply: formula - mohamedali from mak wrote on August 30, 2003 5:34 PM EST
aLAN Posted on: 31-12-1969
Hi Mihamedali,
All of the standard (core) functions are listed in Excel's help sections.
Alan.
Copy, pasteetc
Chitra Posted on: 31-12-1969
Jill, there are 4 shortcuts,
Copy - Ctrl C
Paste - Enter
Multiple Paste - Ctrl V
Cut - Ctrl X
Uppercase
Connie Fink Posted on: 31-12-1969
How do you convert lowercase text to uppercase text without retyping?Reply: Uppercase - Connie Fink from Ann Arbor, MI wrote on September 2, 2003 2:46 PM EST
Alan Posted on: 31-12-1969
Hi Connie,
Use the UPPER function?
Alan.
Filtering
Liam Hoy Posted on: 31-12-1969
Is there any way in excell to filter a record as soon as it is entered instead of always going to data, fiter. i would like it so every time i enter a new record into a row it will jump into the right order on the spreadsheet!Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
