 |
|||
|
|
MS-Excel Shortcut Keys - 3 |
||
|
|
Inserting and Deleting Cells |
||
|
|
CTRL + - |
Delete the selected cells. |
|
|
|
CTRL + SHIFT + + |
Insert cells. |
|
|
|
Working with Formulas |
||
|
|
= |
Start creating a formula. |
|
|
|
ENTER |
Enter the formula in the cell. |
|
|
|
CTRL + SHIFT + ENTER |
Enter the formula as an array formula. |
|
|
|
SHIFT + F3 |
Display the Insert Function dialog box. |
|
|
|
CTRL + A |
Display the Function Arguments dialog box. |
|
|
|
CTRL + SHIFT + A |
Enter the argument names in the Formula bar. |
|
|
|
F3 |
Displays the Paste Name dialog box. |
|
|
|
ALT + = |
Insert an AutoSum formula in the active cell. |
|
|
|
CTRL + SHIFT + " |
Copy the value of the cell above the active cell. |
|
|
|
CTRL + ' |
Copy the formula from the cell above the active cell. |
|
 |
Recalculating Worksheets and Workbooks |
||
|
F9 |
Recalculating all the worksheets in all the open workbooks. |
||
|
SHIFT + F9 |
Recalculating the active worksheet only. |
||
|
CTRL + ALT + F9 |
Recalculating all calculations in all the worksheets in all the open workbooks. |
||
|
CTRL + ALT + SHIFT + F9 |
Recheck all formulas, then recalculate all calculation in all the worksheets. |
||
|
Formatting Cells |
|||
|
ALT + ' |
Display the Style dialog box. |
||
|
CTRL + 1 |
Display the Format Cells dialog box. |
||
|
CTRL + SHIFT + ~ |
Apply the General format. |
||
|
CTRL + SHIFT + $ |
Apply the two-decimal-place Currency format. |
||
|
CTRL + SHIFT + % |
Apply the Percentage format ( no decimal places). |
||
|
CTRL + SHIFT + ^ |
Apply the Exponential format with two decimal places. |
||
|
CTRL+ SHIFT + # |
Apply the DD-MM-YY date format. |
||
|
CTRL + SHIFT+ @ |
Apply the HH:MM AM/PM time format. |
||
|
CTRL + SHIFT + ! |
Apply the two-decimal-place number format with the thousands separator. |
||
|
CTRL + 5 |
Toggle strikethrough. |
||
|
Applying Boarders |
|||
|
CTRL + SHIFT + & |
Apply an outline border. |
||
|
CTRL + SHIFT + _ |
Remove the outline boarder. |
||
|
ALT +T |
Toggle the top boarder on the selected cell. |
||
|
ALT + B |
Toggle the bottom boarder on the selected cells. |
||
|
ALT + L |
Toggle the left border on the selected cells. |
||
|
ALT + R |
Toggle the right boarder on the selected cells. |
||
|
ALT + D |
Toggle the downward diagonal boarder on the selected cells. |
||
|
ALT + U |
Toggle the upward diagonal boarder on the selected cells. |
||
|
ALT + H |
Toggle the horizontal boarder on the selected cells. |
||
|
ALT + V |
Toggle the vertical boarder on the selected cells. |
||
|
Hiding and Unhiding Rows and Columns |
|||
|
CTRL + 9 |
Hide all selected rows. |
||
|
CTRL + 0 |
Hide all selected columns. |
||
|
CTRL + SHIFT + { |
Unhide hidden rows in the selection |
||
|
CTRL + SHIFT + } |
Unhide hidden columns in the selection. |
||
|
Creating and Navigating in Charts |
|||
|
F11, ALT + F1 |
Create a chart from the selected range. |
||
|
A Web Designed by M.Mohan Rao, E-mail:- cheers.mohan@gmail.com |
|||
|
Windows XP || MS-Notepad || MS-WordPad || MS-Paint || MS-Word || MS-Excel || MS-PowerPoint || MS-Access || MS-Outlook || MS-FrontPage || Adobe PhotoShop || Adobe Flash || Adobe PageMaker || Adobe CorelDraw || Internet Explorer || Mozilla Firefox || |
|||
|
Copyright 2010 © www.shortcutkeys.50webs.com |
|||
