|
Ctrl+"
|
Ctrl
"
|
Copy Value from Cell Above
|
Edit Paste Special Value
|
|
Ctrl+'
|
Ctrl
'
|
Copy Fromula from Cell Above
|
Edit Copy
|
|
Shift
|
Shift
|
Hold down shift for additional
functions in Excel's menu
|
none
|
|
Shift+F1
|
Shift
F1
|
What's This?
|
Help What's This?
|
|
Shift+F2
|
Shift
F2
|
Edit cell comment
|
Insert Edit Comments
|
|
Shift+F3
|
Shift
F3
|
Paste function into formula
|
Insert Function
|
|
Shift+F4
|
Shift
F4
|
Find Next
|
Edit Find Find Next
|
|
Shift+F5
|
Shift
F5
|
Find
|
Edit Find Find Next
|
|
Shift+F6
|
Shift
F6
|
Previous Pane
|
None
|
|
Shift+F8
|
Shift
F8
|
Add to selection
|
None
|
|
Shift+F9
|
Shift
F9
|
Calculate active worksheet
|
Calc Sheet
|
|
Shift+F10
|
Shift
F10
|
Display shortcut menu
|
None
|
|
Shift+F11
|
Shift
F11
|
New worksheet
|
Insert Worksheet
|
|
Shift+F12
|
Shift
F12
|
Save
|
File Save
|
|
Ctrl+F3
|
Ctrl
F3
|
Define name
|
Insert Names Define
|
|
Ctrl+F4
|
Ctrl
F4
|
Close
|
File Close
|
|
Ctrl+F5
|
Ctrl
F5
|
XL Restore window size
|
Restore
|
|
Ctrl+F6
|
Ctrl
F6
|
Next workbook window
|
Window ...
|
|
Shift+Ctrl+F6
|
Shift
Ctrl
F6
|
Previous workbook window
|
Window ...
|
|
Ctrl+F7
|
Ctrl
F7
|
Move window
|
XL Move
|
|
Ctrl+F8
|
Ctrl
F8
|
Resize window
|
XL Size
|
|
Ctrl+F9
|
Ctrl
F9
|
Minimize workbook
|
XL Minimize
|
|
Ctrl+F10
|
Ctrl
F10
|
Maximize or restore window
|
XL Maximize
|
|
Ctrl+F11
|
Ctrl
F11
|
Inset 4.0 Macro sheet
|
None in Excel 97. In versions
prior to 97 - Insert Macro 4.0 Macro
|
|
Ctrl+F12
|
Ctrl
F12
|
File Open
|
File Open
|
|
Alt+F1
|
Alt
F1
|
Insert Chart
|
Insert Chart...
|
|
Alt+F2
|
Alt
F2
|
Save As
|
File Save As
|
|
Alt+F4
|
Alt
F4
|
Exit
|
File Exit
|
|
Alt+F8
|
Alt
F8
|
Macro dialog box
|
Tools Macro Macros
in Excel 97 Tools Macros - in earlier versions
|
|
Alt+F11
|
Alt
F11
|
Visual Basic Editor
|
Tools Macro Visual
Basic Editor
|
|
Ctrl+Shift+F3
|
Ctrl
Shift
F3
|
Create name by using names of row
and column labels
|
Insert Name Create
|
|
Ctrl+Shift+F6
|
Ctrl
Shift
F6
|
Previous Window
|
Window ...
|
|
Ctrl+Shift+F12
|
Ctrl
Shift
F12
|
Print
|
File Print
|
|
Alt+Shift+F1
|
Alt
Shift
F1
|
New worksheet
|
Insert Worksheet
|
|
Alt+Shift+F2
|
Alt
Shift
F2
|
Save
|
File Save
|
|
Alt+=
|
Alt
=
|
AutoSum
|
No direct equivalent
|
|
Ctrl+`
|
Ctrl
`
|
Toggle Value/Formula display
|
Tools Options View
Formulas
|
|
Ctrl+Shift+A
|
Ctrl
Shift
A
|
Insert argument names into formula
|
No direct equivalent
|
|
Alt+Down arrow
|
Alt
|
Display AutoComplete list
|
None
|
|
Alt+'
|
Alt
'
|
Format Style dialog box
|
Format Style
|
|
Ctrl+Shift+~
|
Ctrl
Shift
~
|
General format
|
Format Cells Number
Category General
|
|
Ctrl+Shift+!
|
Ctrl
Shift
!
|
Comma format
|
Format Cells Number
Category Number
|
|
Ctrl+Shift+@
|
Ctrl
Shift
@
|
Time format
|
Format Cells Number
Category Time
|
|
Ctrl+Shift+#
|
Ctrl
Shift
#
|
Date format
|
Format Cells Number
Category Date
|
|
Ctrl+Shift+$
|
Ctrl
Shift
$
|
Currency format
|
Format Cells Number
Category Currency
|
|
Ctrl+Shift+%
|
Ctrl
Shift
%
|
Percent format
|
Format Cells Number
Category Percentage
|
|
Ctrl+Shift+^
|
Ctrl
Shift
^
|
Exponential format
|
Format Cells Number
Category,
|
|
Ctrl+Shift+&
|
Ctrl
Shift
&
|
Place outline border around
selected cells
|
Format Cells Border
|
|
Ctrl+Shift+_
|
Ctrl
Shift
_
|
Remove outline border
|
Format Cells Border
|
|
Ctrl+Shift+*
|
Ctrl
Shift
*
|
Select current region
|
Edit Goto Special
Current Region
|
|
Ctrl++
|
Ctrl
+
|
Insert
|
Insert (Rows, Columns, or
Cells) Depends on selection
|
|
Ctrl+-
|
Ctrl
-
|
Delete
|
Delete (Rows, Columns, or
Cells) Depends on selection
|
|
Ctrl+1
|
Ctrl
1
|
Format cells dialog box
|
Format Cells
|
|
Ctrl+2
|
Ctrl
2
|
Bold
|
Format Cells Font
Font Style Bold
|
|
Ctrl+3
|
Ctrl
3
|
Italic
|
Format Cells Font
Font Style Italic
|
|
Ctrl+4
|
Ctrl
4
|
Underline
|
Format Cells Font
Font Style Underline
|
|
Ctrl+5
|
Ctrl
5
|
Strikethrough
|
Format Cells Font
Effects Strikethrough
|
|
Ctrl+6
|
Ctrl
6
|
Show/Hide objects
|
Tools Options View
Objects Show All/Hide
|
|
Ctrl+7
|
Ctrl
7
|
Show/Hide Standard toolbar
|
View Toolbars Stardard
|
|
Ctrl+8
|
Ctrl
8
|
Toggle Outline symbols
|
None
|
|
Ctrl+9
|
Ctrl
9
|
Hide rows
|
Format Row Hide
|
|
Ctrl+0
|
Ctrl
0
|
Hide columns
|
Format Column Hide
|
|
Ctrl+Shift+(
|
Ctrl
Shift
(
|
Unhide rows
|
Format Row Unhide
|
|
Ctrl+Shift+)
|
Ctrl
Shift
)
|
Unhide columns
|
Format Column Unhide
|
|
Alt or F10
|
Alt
/
F10
|
Activate the menu
|
None
|
|
Ctrl+Tab
|
Ctrl
Tab
|
In toolbar: next toolbar
|
None
|
|
Ctrl+Tab
|
Ctrl
Tab
|
In a workbook: activate next
workbook
|
None
|
|
Shift+Ctrl+Tab
|
Shift
Ctrl
Tab
|
In toolbar: previous toolbar
|
None
|
|
Shift+Ctrl+Tab
|
Shift
Ctrl
Tab
|
In a workbook: activate previous
workbook
|
None
|
|
Tab
|
Tab
|
Next tool
|
None
|
|
Shift+Tab
|
Shift
Tab
|
Previous tool
|
None
|
|
Enter
|
Enter
|
Do the command
|
None
|
|
Shift+Ctrl+F
|
Shift
Ctrl
F
|
Font Drop Down List
|
Format Cells Font
|
|
Shift+Ctrl+F+F
|
Shift
Ctrl
F
F
|
Font tab of Format Cell Dialog box
|
Format Cells Font
|
|
Shift+Ctrl+P
|
Shift
Ctrl
P
|
Point size Drop Down List
|
Format Cells Font
|
No comments:
Post a Comment