Electronic Spreadsheets
like MS-Excel 2010 are perhaps one of the most useful tools for excel users.
Excel 2010 provides simple and easy interface to undertake requisite
computations. Excel 2010 also provides readymade financial and other functions,
simulation facility etc. The case studies and exercises given below will
provide thorough practice on financial functions and computations.
Shortcut Keys
(a)
Function Keys
Shortcut
key Functionality
1.
F1 Displays the
Microsoft Office Excel Help task pane
2.
F2 Edits the
active cell, putting the cursor at the end
3.
F3 Displays the
Paste Name dialog box
4.
F4 Repeats the
last command or action, if possible
5.
F5 Displays the
Go To dialog box
6.
F6 Switches
between the worksheet, Ribbon, task pane, and Zoom controls. In a worksheet
that has been split, it also includes the split panes.
7.
F7 Displays the
Spelling dialog box
8.
F8 Turns extend
mode on or off
9.
F9 Calculates all
worksheets in all open workbooks
10. F10 Turns
key tips on or off
11. F11 Creates
a chart (on a chart sheet) using the highlighted range
12. F12 Displays
the Save As dialog box
(b) SHIFT + Function Keys
Shortcut
key Functionality
1.
Shift + F2 Inserts
or edits a cell comment
2.
Shift + F3 Displays
the Insert Function dialog box
3.
Shift + F4 Repeats
the last Find, the same as Find Next
4.
Shift + F5 Displays
the Find dialog box 34
5.
Shift + F6 Switches
between the worksheet, Zoom controls, task pane, and Ribbon
6.
Shift + F8 Enables
the user to add a nonadjacent cell or range to a selection of cells by using
the arrow keys
7.
Shift + F9 Calculates
the active worksheet
8.
Shift + F10 Displays
the (Shortcut) menu for the selected item
9.
Shift + F11 Inserts
a new worksheet
10. Shift + F12 Displays
the Save As dialog box
(c) CTRL + Function Keys
Shortcut
key Functionality
1.
Ctrl + F1 Displays or
hides the Ribbon
2.
Ctrl + F2 Displays the
Print Preview window
3.
Ctrl + F3 Displays the
Name Manager dialog box
4.
Ctrl + F4 Closes the
selected workbook window
5.
Ctrl + F5 Restores the
window size of the selected workbook window
6.
Ctrl + F6 Moves to the
next open workbook or window
7.
Ctrl + F7 Performs the
Move window command when the window is not maximized
8.
Ctrl + F8 Performs the
Size window command when the window is not maximized
9.
Ctrl + F9 Minimizes the
workbook window to an icon
10. Ctrl + F10 Maximizes
or restores the selected workbook window
11. Ctrl + F11 Inserts
a new macro sheet
12. Ctrl + F12 Displays
the Open dialog box
(d) Other + Function keys
Shortcut
key Functionality
1.
Alt + F1 Creates
a chart (on a chart sheet) using the highlighted range
2.
Alt + F2 or Alt + Shift +
F2 Displays the Save As
dialog box
3.
Alt + F4 or Alt + Shift +
F4 Closes all the
workbooks (saving first) and exits Excel
4.
Alt + F8 Displays
the Macro dialog box
5.
Alt + F11 Toggles
between the Visual Basic Editor window (in which one can create a macro using
VBA) and the Excel window
6.
Alt + Ctrl + F9 Calculates
all worksheets in all open workbooks
7.
Alt + Shift + F1 Inserts a new
worksheet
8.
Ctrl + Shift + F3 Displays the
Create Names from Selection dialog box
9.
Ctrl + Shift + F12 Displays the
Print dialog box
(e) CTRL + Number Keys
Shortcut
key Functionality
1.
Ctrl + 0 Hides
the selected columns
2.
Ctrl + 1 Displays
the Format Cells dialog box
3.
Ctrl + 2 Toggles
bold on the current selection
4.
Ctrl + 3 Toggles
italics on the current selection
5.
Ctrl + 4 Toggles
underlining on the current selection
6.
Ctrl + 5 Toggles
the strikethrough of text on the current selection
7.
Ctrl + 6 Alternates
between hiding objects, displaying objects, and displaying place- holders for
objects
8.
Ctrl + 8 Toggles
the display of outline symbols
9.
Ctrl + 9 Hides
the selected rows
(f) CTRL + Alphabet Keys
Shortcut
key Functionality
1.
Ctrl + A Selects
the entire worksheet
2.
Ctrl + B Toggles
bold on the current selection
3.
Ctrl + C Copies
the current selection to the clipboard
4.
Ctrl + D Copies
the contents and format of the first cell in the selection downwards
5.
Ctrl + F Displays
the Find dialog box
6.
Ctrl + G Displays
the Go To dialog box
7.
Ctrl + H Displays
the Replace dialog box
8.
Ctrl + I Toggles
italics on the current selection
9.
Ctrl + K Displays
the Insert Hyperlink dialog box for new hyperlinks or the Edit Hy- perlink
dialog box for selected existing hyperlinks
10. Ctrl + L Displays
the Create Table dialog box
11. Ctrl + N Creates
a new blank workbook
12. Ctrl + O Displays
the Open dialog box
13. Ctrl + P Displays
the Print dialog box
14. Ctrl + R Copies
the contents and format of the leftmost cell in the selection to the right
15. Ctrl + S Saves
the active file
16. Ctrl + U Toggles
underlining on the current selection
17. Ctrl + V Pastes
the contents of the clipboard at the insertion point
18. Ctrl + W Closes
the selected workbook window
19. Ctrl + X Cuts
the current selection to the clipboard
20. Ctrl + Y Repeats
the last command or action, if possible
21. Ctrl + Z Undo
the last command or action
(g) Other Shortcuts
Shortcut
key Functionality
1.
Ctrl + Shift + A Inserts
argument names and parentheses when the insertion point is to the right of a
function name in a formula
2.
Ctrl + Shift + F or Ctrl +
Shift + P Opens the Format Cells
dialog box with the Font tab selected
3.
Ctrl + Shift + O Selects all
the cells with comments
4.
Enter Enters
the contents of the active cell and moves to the cell below 36
5.
Shift + Enter Enters the
contents of the active cell and moves to the cell above
6.
Tab Enters
the contents of the active cell and moves one cell (unlocked in a protected
worksheet) to the right
7.
Shift + Tab Enters
the contents of the active cell and moves one cell (unlocked in a protected
worksheet) to the left
8.
Alt + = Enters
the SUM() function in the active cell
9.
Alt + 0128 Enters
the euro symbol (€) (using Number keypad)
10. Alt + 0162 Enters
the cent symbol (¢) (using Number keypad)
11. Alt + 0163 Enters
the pound sign symbol (£) (using Number keypad)
12. Alt + 0165 Enters
the yen symbol (¥) (using Number keypad)
13. Alt + Enter
Enters a new line (or carriage return) into a cell
14. Ctrl + ' Enters
the formula from the cell directly above into the active cell
15. Ctrl + ; Enters
the current date into the active cell
16. Ctrl + Enter
Enters the contents of the active cell to the selected cell range
17. Ctrl + Shift + : Enters
the current time into the active cell
18. Shift + Insert Enters
the data from the clipboard
19. Alt + Down Arrow Displays
a drop-down list of the values in the current column of a range row
20. Esc Cancels
the cell entry
21. Ctrl + Tab Switches
to the next tab in a dialog box
22. Ctrl + Shift + Tab Switches
to the previous tab in a dialog box
23. Home Moves
to the first column in the current row
24. End + Arrow Key Move
by one block of data within a row or column
25. Page Down Moves
one screen down in a worksheet
26. Page Up Moves
one screen up in a worksheet
27. Alt + Page Down Moves
one screen to the right in a worksheet
28. Alt + Page Up Moves
one screen to the left in a worksheet
29. Ctrl + Home Moves
to the beginning (cell ―A1‖) of a worksheet
30. Ctrl + End Moves
to the last cell on a worksheet, in the lowest used row of the rightmost used
column
31. Ctrl + Arrow Key Moves
to the edge of the current data region
32. Ctrl + Page Up Moves
to the previous worksheet in a workbook
33. Ctrl + Page Down Moves
to the next worksheet in a workbook
34. Scroll Lock + Arrow Key Moves
the workbook window by one cell in the corresponding direction
35. Scroll Lock + End Moves
to the last cell in the current workbook window
36. Scroll Lock + Home Moves
to the first cell in the current workbook window
37. Scroll Lock + Page Down Moves
you down one screen (current selection unchanged)
38. Scroll Lock + Page Up Moves
you up one screen (current selection unchanged)
39. Ctrl + . Moves
clockwise to the next corner within a selected range 37
40. Ctrl + Alt + Left Arrow Switches
to the next non-adjacent selection to the left
41. Ctrl + Alt + Right Arrow Switches
to the next non-adjacent selection to the right = Starts a Formula
42. Ctrl + ` Alternates
between displaying cell values and displaying formulas in the worksheet
43. Ctrl + Delete Deletes
text to the end of the line
44. Ctrl + Insert Copies
the current selection to the clipboard
45. Ctrl + Shift + ( Unhides
any hidden rows within the selection
46. Ctrl + Shift + ) Unhides
any hidden columns within the selection
47. Alt Shows key tips
48. Alt + Shift + Left Arrow Displays
the Ungroup dialog box
49. Alt + Shift + Right Arrow Displays
the Group dialog box
50. Alt + Backspace Undo
the last action
51. Alt + Spacebar Displays
the control menu for the Microsoft Office Excel window
52. Alt + - (from the Numeric keypad) Displays the Excel
application control menu
53. End Moves
to the cell in the lower-right corner of the window when SCROLL LOCK is turned
on.
54. Delete Deletes
the selection or one character to the right
55. Backspace Deletes
the selection or one character to the left
56. Shift + Delete Cuts
the selection to the clipboard
57. Ctrl + - Displays
the Delete dialog box
58. Ctrl + Shift + = Displays
the Insert dialog box
59. Ctrl + Backspace Scrolls
to display the active cell
60. Ctrl + Shift + U Switches
between expanding and collapsing of the formula bar
(h) Selecting data
Shortcut
key Functionality
1.
Ctrl + \ Selects the
cells in a selected row that do not match the value in the active cell
2.
Ctrl + Shift + \ Selects the
cells in a selected column that do not match the value in the active cell
3.
Ctrl + / Selects the
array containing the active cell
4.
Alt + ; Selects the
visible cells in the current selection
5.
Ctrl + Shift + * Selects the current
region around the active cell (surrounded by blank rows and columns). In a
PivotTable, it selects the entire PivotTable report.
6.
Ctrl + [ Selects
all the cells that are directly referred to by the formula in the active cell
(precedents) 38
7.
Ctrl + Shift + [ Selects all
the cells that are directly (or indirectly) referred to by the formula in the
active cell
8.
Ctrl + ] Selects
all the cells that directly refer to the active cell (dependents)
9.
Ctrl + Shift + ] Selects all
the cells that directly (or indirectly) refer to the active cell
10. Ctrl + Shift + Page Selects
the active worksheet and the one after it Down
11. Ctrl + Shift + Selects
the active worksheet and the one before it Page Up
12. Ctrl + Shift + Selects
all the objects on a worksheet when an object is selected or selects the
Spacebar entire worksheet
13. Ctrl + Spacebar Selects
an entire column in a worksheet
14. Shift + Spacebar Selects
an entire row in a worksheet
15. Shift + Arrow Selects
the active cell and the cell in the given direction keys
16. Shift + Backspace Selects
the active cell when multiple cells are selected
(i) Extending data
Shortcut
key Functionality
1.
Ctrl + Shift + Arrow Key Extends the selection to the last
non-blank cell in the same column or row as the active cell, or if the next
cell is blank, extends the selection to the next non-blank cell
2.
Ctrl + Shift + End Extends the selection to the
last used cell on the worksheet
3.
Ctrl + Shift + Extends the selection
to the beginning of the worksheet Home
4.
Shift + Arrow Key Extends the selection by one
cell in that direction
5.
Shift + Home Extends the selection
to the first column
6.
Shift + Page Extends
the selection down one screen Down
7.
Shift + Page Up Extends the selection up
one screen End,
8.
Shift + Arrow Key Extends the selection to the
next non-blank cell in that direction
(j) Formatting data
Shortcut
key Functionality
1.
Alt + ' Displays
the Style dialog box
2.
Ctrl + Shift + ! Applies the
Number format with two decimal places, thousands separator, and minus sign (-)
for negative values
3.
Ctrl + Shift + $ Applies the Currency
format with ―$‖ sign and two decimal places (negative numbers in parentheses)
4.
Ctrl + Shift + % Applies the Percentage
format with no decimal places
5.
Ctrl + Shift + ^ Applies the Exponential
number format with two decimal places
6.
Ctrl + Shift + ~ Applies the General
number format
7.
Ctrl + Shift + @ Applies Time format with
the hour and minute, and AM or PM
8.
Ctrl + Shift + # Applies the Date format
"dd-mmm-yy" to the selection
9.
Ctrl + Shift + & Applies the outline border
to the selected cells
10. Ctrl + Shift + _ Removes
the outline border from the selected cells
Nice but setting required.
ReplyDeleteyes, I will try to set.
Delete