- connection.
Ctrl+A
Select All
None
Ctrl+B
Bold
Format, Cells, Font, Font Style, Bold- Ctrl+C
Copy
Edit, Copy - Ctrl+D
Fill Down
Edit, Fill, Down - Ctrl+F
Find
Edit, Find - Ctrl+G
Goto
Edit, Goto - Ctrl+H
Replace
Edit, Replace - Ctrl+I
Italic
Format, Cells, Font, Font Style, Italic - Ctrl+K
Insert Hyperlink
Insert, Hyperlink - Ctrl+N
New Workbook
File, New - Ctrl+O
Open
File, Open - Ctrl+P
Print
File, Print - Ctrl+R
Fill Right
Edit, Fill Right - Ctrl+S
Save
File, Save - Ctrl+U
Underline
Format, Cells, Font, Underline, Single - Ctrl+V
Paste
Edit, Paste - Ctrl W
Close
File, Close - Ctrl+X
Cut
Edit, Cut - Ctrl+Y
Repeat
Edit, Repeat - Ctrl+Z
Undo
Edit, Undo - F1
Help
Help, Contents and Index - F2
Edit
None - F3
Paste Name
Insert, Name, Paste - F4
Repeat last action
Edit, Repeat. Works while not in Edit mode. - F4
While typing a formula, switch between absolute/relative refs
None - F5
Goto
Edit, Goto - F6
Next Pane
None - F7
Spell check
Tools, Spelling - F8
Extend mode
None - F9
Recalculate all workbooks
Tools, Options, Calculation, Calc,Now - F10
Activate Menubar
N/A - F11
New Chart
Insert, Chart - F12
Save As
File, Save As - Ctrl+:
Insert Current Time
None - Ctrl+;
Insert Current Date
None - Ctrl+"
Copy Value from Cell Above
Edit, Paste Special, Value - Ctrl+’
Copy Fromula from Cell Above
Edit, Copy - Shift
Hold down shift for additional functions in Excel’s menu
none - Shift+F1
What’s This?
Help, What’s This? - Shift+F2
Edit cell comment
Insert, Edit Comments - Shift+F3
Paste function into formula
Insert, Function - Shift+F4
Find Next
Edit, Find, Find Next - Shift+F5
Find
Edit, Find, Find Next - Shift+F6
Previous Pane
None - Shift+F8
Add to selection
None - Shift+F9
Calculate active worksheet
Calc Sheet - Shift+F10
Display shortcut menu
None - Shift+F11
New worksheet
Insert, Worksheet - Shift+F12
Save
File, Save - Ctrl+F3
Define name
Insert, Names, Define - Ctrl+F4
Close
File, Close - Ctrl+F5
XL, Restore window size
Restore - Ctrl+F6
Next workbook window
Window, ... - Shift+Ctrl+F6
Previous workbook window
Window, ... - Ctrl+F7
Move window
XL, Move - Ctrl+F8
Resize window
XL, Size - Ctrl+F9
Minimize workbook
XL, Minimize - Ctrl+F10
Maximize or restore window
XL, Maximize - Ctrl+F11
Inset 4.0 Macro sheet
None in Excel 97. In versions prior to 97 - Insert, Macro, 4.0 Macro - Ctrl+F12
File Open
File, Open - Alt+F1
Insert Chart
Insert, Chart... - Alt+F2
Save As
File, Save As - Alt+F4
Exit
File, Exit - Alt+F8
Macro dialog box
Tools, Macro, Macros in Excel 97 Tools,Macros - in earlier versions - Alt+F11
Visual Basic Editor
Tools, Macro, Visual Basic Editor - Ctrl+Shift+F3
Create name by using names of row and column labels
Insert, Name, Create - Ctrl+Shift+F6
Previous Window
Window, ... - Ctrl+Shift+F12
Print
File, Print - Alt+Shift+F1
New worksheet
Insert, Worksheet - Alt+Shift+F2
Save
File, Save - Alt+=
AutoSum
No direct equivalent - Ctrl+`
Toggle Value/Formula display
Tools, Options, View, Formulas - Ctrl+Shift+A
Insert argument names into formula
No direct equivalent - Alt+Down arrow
Display AutoComplete list
None - Alt+’
Format Style dialog box
Format, Style - Ctrl+Shift+~
General format
Format, Cells, Number, Category, General - Ctrl+Shift+!
Comma format
Format, Cells, Number, Category, Number - Ctrl+Shift+@
Time format
Format, Cells, Number, Category, Time - Ctrl+Shift+#
Date format
Format, Cells, Number, Category, Date - Ctrl+Shift+$
Currency format
Format, Cells, Number, Category, Currency - Ctrl+Shift+%
Percent format
Format, Cells, Number, Category, Percentage - Ctrl+Shift+^
Exponential format
Format, Cells, Number, Category, - Ctrl+Shift+&
Place outline border around selected cells
Format, Cells, Border - Ctrl+Shift+_
Remove outline border
Format, Cells, Border - Ctrl+Shift+*
Select current region
Edit, Goto, Special, Current Region - Ctrl++
Insert
Insert, (Rows, Columns, or Cells) Depends on selection - Ctrl+-
Delete
Delete, (Rows, Columns, or Cells) Depends on selection - Ctrl+1
Format cells dialog box
Format, Cells - Ctrl+2
Bold
Format, Cells, Font, Font Style, Bold - Ctrl+3
Italic
Format, Cells, Font, Font Style, Italic - Ctrl+4
Underline
Format, Cells, Font, Font Style, Underline - Ctrl+5
Strikethrough
Format, Cells, Font, Effects, Strikethrough - Ctrl+6
Show/Hide objects
Tools, Options, View, Objects, Show All/Hide - Ctrl+7
Show/Hide Standard toolbar
View, Toolbars, Stardard - Ctrl+8
Toggle Outline symbols
None - Ctrl+9
Hide rows
Format, Row, Hide - Ctrl+0
Hide columns
Format, Column, Hide - Ctrl+Shift+(
Unhide rows
Format, Row, Unhide - Ctrl+Shift+)
Unhide columns
Format, Column, Unhide - Alt or F10
Activate the menu
None - Ctrl+Tab
In toolbar: next toolbar
None - Shift+Ctrl+Tab
In toolbar: previous toolbar
None - Ctrl+Tab
In a workbook: activate next workbook
None - Shift+Ctrl+Tab
In a workbook: activate previous workbook
None - Tab
Next tool
None - Shift+Tab
Previous tool
None - Enter
Do the command
None - Shift+Ctrl+F
Font Drop Down List
Format, Cells, Font - Shift+Ctrl+F+ F
Font tab of Format Cell Dialog box
Format, Cells, Font - Shift+Ctrl+P
Point size Drop Down List
Format, Cells, Font
Saturday, September 29, 2007
keyboard short cuts
Subscribe to:
Post Comments (Atom)
Featured Posts
Adding Accesspolicy to KeyVault for Service Principal Using Portal and Powershell
Scripts path : https://drive.google.com/drive/folders/1sbBpnVFgXhUIXLdf2E9heyWDeU2f9427?usp=sharing Adding Accesspolicy to KeyVault for S...
-
How many cmdlets are available that can deal with generic objects? (Hint: remember to use a singular noun like “object” rat...
-
Azure Portal Service passes service package to “Red Dog Front End” (RDFE). RDFE converts service package to native “RD” version. RDFE... -
Can you find any cmdlets capable of converting other cmdlets’ output into HTML? Help *html* Or you could try with Get-Command: get-comm...
No comments:
Post a Comment