Docstoc

Shortcuts - JP Excel Training Files

Document Sample
Shortcuts - JP Excel Training Files Powered By Docstoc
					     Excel 2007 Keyboard Shortcuts


     Category        Where used          Shortcut
1
     KeyTips         ---                 ---
2
     KeyTips         Workbook            Office Button KeyTip shortcuts

3
     KeyTips         Ribbons             Ribbon KeyTip shortcuts

4
     Alpha           ---                 ---
5
     Alpha           Cells / Worksheet
                                         Ctrl+A
6
     Alpha           Text                Ctrl+B
7
     Alpha           Cell(s) / Objects   Ctrl+C


8
     Alpha           Cells               Ctrl+D


9
     Alpha           Worksheet           Ctrl+F
10
     Alpha           Worksheet           Ctrl+G
11
     Alpha           Worksheet           Ctrl+H
12
     Alpha           Text                Ctrl+I
13
     Alpha           Cells               Ctrl+K

14
     Alpha           Workbook            Ctrl+N
15
     Alpha           Workbook            Ctrl+O
16
     Alpha           Worksheet           Ctrl+P
17
     Alpha           Cells               Ctrl+R


18
     Alpha           Workbook            Ctrl+S
19
     Alpha           Cells               Ctrl+T
20
     Alpha           Text                Ctrl+U
21
     Alpha           Cells               Ctrl+V
22
     Alpha           Workbook            Ctrl+W


23
     Alpha           Cell(s) / Objects   Ctrl+X
24
     Alpha           Workbook            Ctrl+Y
25
     Alpha           Workbook            Ctrl+Z
26
     Alpha           Worksheet           Ctrl+Shift+O

27
     Number          ---                 ---
28
     Number          Worksheet           Ctrl+1
29
     Number          Text                Ctrl+2
30
     Number          Text                Ctrl+3
31
     Number          Text                Ctrl+4
32
     Number          Text                Ctrl+5
33
     Number          Worksheet           Ctrl+6
34
     Number          Rows / Columns      Ctrl+8

35
     Number          Rows                Ctrl+9
36
     Number          Columns             Ctrl+0
37
     Punctuation     ---          Explanation of Punctuation
                                  Shortcuts



38
     Punctuation     Columns      Ctrl+Shift+0
                                   equivalent to Ctrl+)
39
     Punctuation     Cells        Ctrl+Shift+1
                                   equivalent to Ctrl+!
40
     Punctuation     Cells        Ctrl+Shift+2
                                   equivalent to Ctrl+@
41
     Punctuation     Cells        Ctrl+Shift+3
                                   equivalent to Ctrl+#
42
     Punctuation     Cells        Ctrl+Shift+4
                                   equivalent to Ctrl+$
43
     Punctuation     Cells        Ctrl+Shift+5
                                   equivalent to Ctrl+%
44
     Punctuation     Cells        Ctrl+Shift+6
                                   equivalent to Ctrl+^
45
     Punctuation     Cells        Ctrl+Shift+7
                                   equivalent to Ctrl+&
46
     Punctuation     Cells        Ctrl+Shift+8
                                   equivalent to Ctrl+*
47
     PivotTable      PivotTable   Ctrl+Shift+8
                                   equivalent to Ctrl+*
48
     Punctuation     Rows         Ctrl+Shift+9
                                   equivalent to Ctrl+(
49
     Punctuation     Cells        Ctrl+Shift+- (Minus sign)
                                   equivalent to Ctrl+_
50
     Punctuation     Cells        Ctrl+Shift+' (Back single quote)
                                   equivalent to Ctrl+~
51
     Punctuation     Cells        Ctrl+Shift+; (Semi colon)
                                   equivalent to Ctrl+:
52
     Punctuation     Cells        Ctrl+Shift+' (Single quote)
                                   equivalent to Ctrl+"

53
     Punctuation     Cells        Ctrl+Shift+=
                                   equivalent to Ctrl++ (Plus)
54
     Punctuation     Cells        Ctrl+- (Minus)
55
     Punctuation     Cells        Ctrl+; (Semi colon)
56
     Punctuation     Cells        Ctrl+` (Single back quote)

57
     Punctuation     Cells        Ctrl+' (Single quote)

58
     Function keys   ---          ---

59
     Function keys   Worksheet    F1
60
     Function keys   Worksheet    Ctrl+F1
61
     Function keys   Cells        F2
62
     Function keys   Worksheet    Ctrl+F2
63
     Function keys   Cells        Shift+F2

64
     Function keys   Worksheet    F3
65
     Function keys   Cells        Shift+F3
66
     Function keys   Formula      F4


67
     Function keys   Worksheet    F5
68
      Function keys   Split window        F6

69
      Function keys   Cells               F7
70
      Function keys   Worksheet           F7
71
      Function keys   Cells               F8
72
      Function keys   Worksheet           Alt+F8
73
      Function keys   Worksheet           Shift+F8
74
      Function keys   Worksheet           F9

75
      Function keys   Worksheet           Ctrl+F9
76
      Function keys   Worksheet           Shift+F9
77
      Function keys   Worksheet           F10
78
      Function keys   Cell(s) / Objects   Shift+F10
79
      Function keys   Table / database    F11
80
      Function keys   Worksheet           Alt+F11
81
      Function keys   Worksheet           Shift+F11
82
      Function keys   Worksheet           F12
83
      Command keys    Various             Command key shortcuts


84
      Command keys    Everywhere          Esc
85
      Command keys    Cells               Enter
86
      Command keys    Cells               Alt+Enter
87
      Command keys    Many places         Arrow keys
88
      Command keys    Cells               Ctrl+Arrow key
89
      Command keys    Cells               Shift+Arrow key
90
      Command keys    Cells               Ctrl+Shift+Arrow key
91
      Command keys    Cells / Worksheet   Home
92
      Command keys    Cells / Worksheet   Ctrl+Home
93
      Command keys    Cells / Worksheet   Shift+Home

94
      Command keys    Cells / Worksheet   Ctrl+Shift+Home
95
      Command keys    Cells / Worksheet   End
96
      Command keys    Cells / Worksheet   Ctrl+End
97
      Command keys    Cells / Worksheet   Shift+End

98
      Command keys    Cells / Worksheet   Ctrl+Shift+End
99
      Command keys    Cells / Worksheet   Delete
100
      Command keys    Cells               Backspace
101
      Command keys    Worksheet           Ctrl+Backspace
102
      Command keys    Worksheet           Page Up
103
      Command keys    Worksheet           Page Down
104
      Command keys    Workbook            Ctrl+Page Up
105
      Command keys    Workbook            Ctrl+Page Down
106
      Command keys    Worksheet           Shift+Page Up
107
      Command keys    Worksheet           Shift+Page Down
108
      Command keys    Worksheet           Alt+Page Up
109
      Command keys    Worksheet           Alt+Page Down
110
      Command keys    Workbook            Ctrl+Shift+Page Up
111
      Command keys    Workbook            Ctrl+Shift+Page Down
112
      Command keys    Cells               Tab

113
      Command keys    Cells               Shift+Tab
114
      Command keys    Workbook            Ctrl+Tab
115
      Command keys    Computer            Alt+Tab
116
      Command keys    Worksheet           Print Screen
117
      Command keys    Window              Alt+Print Screen
118
      Dialogue box   Dialogue box          Dialogue box shortcuts


119
      Help window    Help window           Help window shortcuts


120
      Help window    Worksheet             F1
121
      Help window    Help window           Alt+F4
122
      Tables         Tables                Table shortcuts


123
      Task Panes     Task panes            Task pane shortcuts


124
      Excel 2003     2003 Menu Shortcuts   Excel 2003 menu shortcuts –
                                           Explanation



125
      Excel 2003     File Menu             Alt+F_A
126
      Excel 2003     File Menu             Alt+F_C


127
      Excel 2003     File Menu             Alt+F_D


128
      Excel 2003     File Menu             Alt+F_N
129
      Excel 2003     File Menu             Alt+F_O
130
      Excel 2003     File Menu             Alt+F_P
131
      Excel 2003     File Menu             Alt+F_S
132
      Excel 2003     Edit Menu             Alt+E_B
133
      Excel 2003     Edit Menu             Alt+E_C
134
      Excel 2003     Edit Menu             Alt+E_F

135
      Excel 2003     Edit Menu             Alt+E_G
136
      Excel 2003     Edit Menu             Alt+E_P
137
      Excel 2003     Edit Menu             Alt+E_S

138
      Excel 2003     Edit Menu             Alt+E_S_C

139
      Excel 2003     Edit Menu             Alt+E_S_N

140
      Excel 2003     Edit Menu             Alt+E_S_V

141
      Excel 2003     Edit Menu             Alt+E_S_W

142
      Excel 2003     Edit Menu             Alt+E_T
143
      Excel 2003     Edit Menu             Alt+E_U

144
      Excel 2003     View Menu             Alt+V_F
145
      Excel 2003     View Menu             Alt+V_N
146
      Excel 2003     View Menu             Alt+V_P
147
      Excel 2003     Insert Menu           Alt+I_B

148
      Excel 2003     Insert Menu           Alt+I_E
149
      Excel 2003     Insert Menu           Alt+I_I

150
      Excel 2003     Insert Menu           Alt+I_R
151
       Excel 2003         Insert Menu              Alt+I_S

152
       Excel 2003         Insert Menu              Alt+I_W

153
       Excel 2003         Format Menu              Alt+O_D

154
       Excel 2003         Format Menu              Alt+O_E
155
       Excel 2003         Tools Menu               Alt+T_A
156
       Excel 2003         Tools Menu               Alt+T_O


157
       Excel 2003         Tools Menu               Alt+T_S

158
       Excel 2003         Data Menu                Alt+D_F_F

159
       Excel 2003         Data Menu                Alt+D_L
160
       Excel 2003         Data Menu                Alt+D_O
161
       Excel 2003         Data Menu                Alt+D_S
162
       Excel 2003         Window Menu              Alt+W_A

163
       Excel 2003         Window Menu              Alt+W_N

164

165
           Dealing with complexity is an inefficient and unnecessary waste of
      time, attention and mental energy. There is never any justification for things
               being complex when they could be simple. (Edward deBono)
There are a few notes about this worksheet in column G. Scroll right to see them.



What the Keyboard Shortcut does …
KeyTips are shown on the Office Button drop-down or Ribbon when Alt or F10 is pressed.
Office Button KeyTip shortcuts are explained on the Keyboard worksheet in Training File b of
the JP Excel 2007 Training Files.
Ribbon KeyTip shortcuts are explained on the Keyboard worksheet in Training File b of the JP
Excel Training Files.
Alpha shortcuts use Ctrl or Ctrl+Shift plus an alphabetical key
Selects a block of contiguous cells or an entire worksheet. This shortcut is explained on the
Keyboard worksheet. The hyperlink at left will take you there.
Applies or removes bold formatting. Ctrl+2 does the same thing.
Copies the selected cell(s) or object(s) to the Clipboard. Pressing Ctrl+C twice displays the
Clipboard (but only if that option is selected in the Options drop-down at the bottom of the
Clipboard task pane).
Equivalent to the Fill Down command. Copies the contents and format of the top cell of a
selected range into the cells below. Beware … if any of the cells in the range are non-blank, they
will be overwritten with what's in the cell being filled down.
Display the Find and Replace dialogue box, with the Find tab selected.
Display the Go To dialogue box. F5 does the same thing.
Display the Find and Replace dialogue box, with the Replace tab selected.
Applies or removes italic formatting. Ctrl+3 does the same thing.
Display the Insert Hyperlink dialogue box. If there is already a hyperlink in the cell, displays the
Edit Hyperlink dialogue box.
Opens a new workbook.
Display the file Open dialogue box to select and open an Excel file.
Display the Print dialogue box.
Equivalent to the Fill Right command. Copies the contents and format of the left most cell of a
selected range into the cells to the right. Beware … if any of the cells in the range are non-blank,
they will be overwritten with what's in the cell being filled right.
Saves the active workbook.
Display the Create Table dialogue box to create an Excel Table .
Applies or removes underline formatting. Ctrl+4 does the same thing.
Paste the last copied item to (or into) the selected cell.
Close the active workbook. Eqivalent to clicking on the X (close window) button at top right of
workbook. If changes have been made since the file was opened, or since the last File Save
command, a dialogue box asking if you want to save the changes will be displayed.
Cuts the selected cell(s) or objects so they can be pasted elsewhere.
Repeat the last command or action (if possible).
Undo the last command or action (if possible).
Selects all cells that contain comments. This is equivalent to Go To Special_Comments which
can be accessed via Home(Editing)_Find & Select.
Number shortcuts use Ctrl plus an alphabetical key
Display the Format Cells dialogue box.
Applies or removes bold formatting. Ctrl+B does the same thing.
Applies or removes italic formatting. Ctrl+I does the same thing.
Applies or removes underline formatting. Ctrl+U does the same thing.
Applies or removes strikethrough formatting.
Toggles between hiding / displaying objects and displaying placeholders for objects.
Display or hide the outline symbols. Refers to outlines that have been applied to rows and / or
columns via Data(Outline)_Group .
Hides selected rows.
Hides selected columns.
Listed below are keyboard shortcuts that use Ctrl+ a punctuation character. However, many of
the punctuation characters are in upper case on the keyboard, so Shift must be pressed to
access them. Therefore, in Column D, shortcuts are shown in the format Ctrl+Shift+key where
key is the nominal (lower case) character, e.g. a number, and the equivalent, i.e.
Ctrl+(punctuation character) is shown in grey font.
Unhides any hidden columns within a selection of cells or columns that includes hidden columns.

Applies the Number format with two decimal places, thousands separator and minus sign (-) for
negative values.
Applies the Time format hh:mm with suffix AM or PM.

Applies the Date format dd-mmm-yy to a cell containing a date or number that Excel can
interpret as a date.
Applies the Currency format with two decimal places and negative numbers in (brackets).

Applies the Percentage format with no decimal places.

Applies the Exponential number format with two decimal places.

Puts a default outline border around selected cell(s).

Selects the current region around the active cell (the data area enclosed by blank rows and
blank columns).
Selects the entire PivotTable report .

Unhides any hidden rows within a selection of cells in a column or selection of rows that includes
hidden rows.
Removes an outline border from selected cell(s).

Applies the General number format , which is the default format for cells, so this shortcut is only
of use in a cell or cells that have been formatted differently.
Enters the current time (as set on the computer) in format hh:mm with suffix AM or PM.

Copies the displayed value from the cell above the active cell into the active cell. Note: If the
cell above the active cell contains a formula, it is the value that will be copied, not the formula
iteself. Also see Ctrl+'
Display the Insert Cells dialogue box.

Display the Delete Cells dialogue box.
Enters the current date (as set on the computer) in the format dd/mm/yyyy or mm/dd/yyyy.
Toggles between showing formulae or their calculated results in cells that contain formulae.
When formulae are displayed, cells may increase in width until Ctrl+` is pressed again.
Copies a formula from the cell above the active cell into the active cell. If the cell above the
active contains text instead of a formula, the text will be copied. Also see Ctrl+Shift+"
Function key shortcuts can be a sigle keystroke or a function key used in combination with the
Alt, Ctrl or Shift keys.
Display the Help window.
Does the same as double clicking a Ribbon tab, shows or hides the Ribbon.
When the active cell is in Ready mode or Enter mode, puts active cell into Edit mode.
Puts a worksheet into Print Preview.
If there is no comment in the active cell, inserts a comment and puts the comment into edit mode.
If there is a comment already in the cell, puts the comment into edit mode.
Displays the Paste Name dialogue box. See further details on the Keyboard worksheet.
Displays the Insert Function dialogue box.
Selecting a cell or range reference in a formula and pressing F4 cycles the reference type from
relative to absolute to mixed (a) to mixed (b) then back to relative … etc. Click on the hyperlink at
left to see a demonstration.
Displays the Go To dialogue box.
F6 can only be used when a window has been split via View(Window)_Split and pressing F6
moves from one split section to the next.
When a cell is in Enter or Edit mode, F7 launches a spelling check on the text in the cell.
When active cell is in Ready mode, F7 launches a spelling check on the whole worksheet.
Only works when a cell is in Ready mode and turns Extend Selection on or off.
Displays the Macro dialogue box.
Allows selecting non-adjacent cells when a worksheet is in Extend Selection mode.
F9 is the calculate now key, causes all formulae on all worksheets in open Excel files to
calculate. Only necessary when calculation is set to Manual in Excel Options.
Minimises a workbook to an icon on the Task Bar.
Calculates the active worksheet.
Turns KeyTips on or off. For details on KeyTips click on the hyperlink at left.
Does the same as right clicking a cell or object, displays a shortcut or pop-up menu.
When the active cell is in a suitable table or database, pressing F11 creates a chart.
Opens the Visual Basic Editor.
Inserts and selects a new worksheet.
Displays the Save As dialogue box.
These keys command Excel to do something other than put a character into a cell. Command
keys are explained on the Keyboard worksheet. Hyperlinks in Column D below will take you to
the relevant section on that worksheet.
Esc (Escape) is the "get out" key.
Completes an editing process. Moves to the next cell.
Starts a new line of text in a cell.
Arrow keys and their shortcuts can do many things. See Keyboard worksheet.
Moves to the edge of a data region.
Selects cells.
Selects from active cell to edge of region.
Moves to home position of cell or row in cell or on worksheet.
Moves to home position of cell or worksheet.
Moves to home position of cell or row in cell or on worksheet, selecting characters or cells as it
goes.
Moves to home position of cell or worksheet, selecting characters or cells as it goes.
Moves to end position of cell or row in cell.
Moves to end position of cell or worksheet.
Moves to end position of cell or row in cell or on worksheet, selecting characters or cells as it
goes.
Moves to end position of cell or worksheet, selecting characters or cells as it goes.
Deletes selected character to right of insertion point, cell, range or object.
Delete character to left of insertion point.
Returns to active cell after scrolling workheet using scroll bars or mouse wheel.
Moves up one page on the active worksheet.
Moves down one page on the active worksheet.
Moves to previous worksheet in a workbook.
Moves to next worksheet in a workbook.
Selects from active cell to one page up.
Selects from active cell to one page down.
Scrolls active worksheet one page to the left.
Scrolls active worksheet one page to the right.
Selects (groups) active worksheet and previous worksheet.
Selects (groups) active worksheet and next worksheet.
Moves active cell one cell to the right. Moves between unprotected cells on a protected
worksheet.
Moves active cell one cell to the left.
Cycles through open workbooks.
Cycles through open applications on the computer.
Copies picture of Excel screen to the Clipboard.
Copies active window or dialogue box to the Clipboard.
To see a list of shortcuts that can be used in Dialogue boxes, display the Help window and type
"Ribbon, Help," into the search field, then select the topic Ribbon, Help, and other Microsoft
Office keyboard shortcuts.
To see a list of shortcuts that can be used in the Help window, display the Help window and type
"Ribbon, Help," into the search field, then select the topic Ribbon, Help, and other Microsoft
Office keyboard shortcuts.
Display the Help window.
Close Help window.
To see a list of shortcuts that can be used in Tables, display the Help window and type "Ribbon,
Help," into the search field, then select the topic Ribbon, Help, and other Microsoft Office
keyboard shortcuts.
To see a list of shortcuts that can be used in Task panes, display the Help window and type
"Ribbon, Help," into the search field, then select the topic Ribbon, Help, and other Microsoft
Office keyboard shortcuts.
Listed below are some of the Excel 2003 menu shortcuts that work in Excel 2007.
If the Alt+F shortcuts are used, the Office Button drop-down (showing KeyTips) will be displayed.
If Alt+W shortcuts are used, the View Ribbon (showing KeyTips) will be displayed. Most (but not
all) KeyTips are the same as the accelerator keys that were shown in Excel 2003 menus.

Display the file Save As dialogue box.
Close the active workbook. If changes have been made since the file was opened, or since the
last File Save command, a dialogue box asking if you want to save the changes will be displayed.

In Excel 2007 this shortcut displays a two item menu on the right side of the Office Button drop-
down. This allows selecting E for email or X for Internet fax service. In Excel 2003 it displayed a
sub-menu with several options.
Open a new Excel workbook. Ctrl+N does the same thing.
Display file Open dialogue box. Ctrl+O does the same thing.
Display the Print dialogue box. Ctrl+P does the same thing.
Save the active workbook. Ctrl+S does the same thing.
Display the Office Clipboard.
Copy. Ctrl+C does the same thing.
Display the Find and Replace dialogue box with the Find tab selected. Ctrl+F does the same
thing.
Display the Go To dialogue box. Ctrl+G does the same thing.
Paste. Ctrl+V does the same thing.
Display the Paste Special dialogue box. Pressing an accelerator key from the dialogue box will
perform that action. See a few examples in Column D (they start with Alt+E_S ).
Paste Special_Comments . Used after copying a cell containing a comment, to paste just the
comment into the destination cell without affecting anything else that is in the cell.
Paste Special_Data Validation . Used after copying a validated cell, to paste the same data
validation into the destination cell without affecting anything else that is in the cell.
Paste Special_Values. Used after copying a formula to paste the calculated value into the same
cell, i.e. replace the formula with a value.
Paste Special_Columns widths. Used after copying column(s) to paste the same column widths
in other columns.
Cut. Ctrl+X does the same thing.
Undo, but only if something has been done that can be undone, e.g. something was deleted.
Ctrl+Z does the same thing.
Hide / show the Formula Bar.
Display the active worksheet in Normal view.
Display the active worksheet in Page Break Preview view.
Insert Page Break above and to the left of the active cell. Alt+I_B again in the same cell
removes the page break.
Display the Insert Cells dialogue box.
Display the Insert Hyperlink dialogue box. If there is already a hyperlink in the cell, displays the
Edit Hyperlink dialogue box. Ctrl+K does the same thing.
Insert a row above the row of the active cell.
  Display the Insert Symbol dialogue box. Symbols are characters from other character sets, e.g.
  Wingdings symbols ... 
  Insert a worksheet. An easier way to do this in Excel 2007 is to click on the Insert Worksheet
  button at the right of the worksheet tabs.
  In Excel 2003 this shortcut displayed the Conditional Formatting dialogue box, but in Excel 2007
  it displays the Conditional Formatting Rules Manager dialogue box.
  Display the Format Cells dialogue box. Ctrl+1 does the same thing.
  Display the AutoCorrect dialogue box.
  In Excel 2003 this shortcut displayed the Options dialogue box. In Excel 2007 this shortcut
  displays the quite different looking Excel Options window (that still has most of the same options
  on it).
  Perform a spelling check within a cell that is in Enter or Edit mode or for an entire worksheet
  when the active cell is in Ready mode . F7 does the same thing.
  Toggle AutoFilter on or off in a database (the second F in the shortcut is because Alt+D_F in
  Excel 2003 displayed a sub-menu on which the accelerator key F was AutoFilter).
  Display the Data Validation dialogue box.
  Display a data entry form with fields for the column headings in a database.
  Display the (custom) Sort dialogue box.
  Display the Arrange Windows dialogue box, which allows displaying two or more worksheet
  windows (from the same or different workbooks) on screen at the same time.
  Open a new window (used when two windows of the same workbook are to be arranged on the
  screen).


   Knowing some keyboard shortcuts (if you are a proficient keyboard user) is often helpful and saves mouse
clicks … but trying to remember too many is an unnecessary waste of time. My advice is to learn a few that you
                             will use often and don't worry about the others. (JP).
Some notes about this worksheet
To read these notes, the database at left must be sorted smallest to largest on Column A
(so row heights will match the text) and the active cell must be at the top of the worksheet.
.
This worksheet contains some (but not all) of the keyboard shortcuts that can be used in
Microsoft Office Excel 2007 (others can be found in Excel Help).

It can be filtered or sorted on any column(s) from B to D and returned to the original order by
sorting Column A from smallest to largest.

The Categories in Column B are not Microsoft or Excel categories, they are simply
categories that were assigned to group similar shortcuts on this worksheet.

Entries in Column C (Where Used ) are where a listed shortcut can be used to do what is shown
in Column E. However, there may an identical shortcut that can be used to do
something different (or perhaps the same) in another place, e.g. in the Help window.

The easiest keyboard shortcuts to remember are the Office Button and Ribbon shortcuts,
because as soon as the Alt key or F10 is pressed, the KeyTips appear to guide you, so it
is not really necessary to remember any of the KeyTip shortcuts.

There are some shortcuts in the list at left that you may find very useful. It is therefore
suggested that you browse through the shortcuts on this worksheet and make a note of any that
you may find useful.

Many of the shortcuts that I find useful to remember are listed on the Keyboard worksheet,
and most of those have a hyperlink in Column D on this worksheet. It is therefore possible
to filter for those shortcuts by filtering Column D for colour blue.

The top few keyboard shortcuts that might be useful to remember are …

Ctrl+X … Cut
Ctrl+C … Copy
Ctrl+V … Paste
Alt+E_S_V … Paste Special_Values (used after copying a cell containing a formula)
Ctrl+Arrow and some of the other Command Key shortcuts … filter for Command Keys in
                          Column B at left or see the Keyboard worksheet for details.
Ctrl+F … Display the Find and Replace dialogue box.
Ctrl+` … Show / hide formulae
F1 … Display the Help window
F2 … When the active cell is in Enter or Ready mode , puts the cell into Edit mode.
F4 … Change the cell reference type in a formula or function dialogue box.

There is, of course, nothing stopping you from doing a Try it now … on any of the listed
shortcuts – and if you don't want to use keyboard shortcuts at all, that's OK, because the
mouse can be used to most things that can be done by shortcuts – and one of the easiest
ways to access shortcuts using the mouse, is to right click on a cell, a range or an object.

                                         …ooo000ooo…
      www.jpexceltraining.com
 Note: There are other free Excel files that
can be downloaded from the above web site.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:14
posted:10/19/2011
language:English
pages:12