Sneltoetsen

SneltoetsActie
Ctrl+ASelect All
Ctrl+BBold
Ctrl+CCopy
Ctrl+DFill Down
Ctrl+FFind
Ctrl+GGoto
Ctrl+HReplace
Ctrl+IItalic
Ctrl+KInsert Hyperlink
Ctrl+NNew Workbook
Ctrl+OOpen
Ctrl+PPrint
Ctrl+RFill Right
Ctrl+SSave
Ctrl+UUnderline
Ctrl+VPaste
Ctrl WClose
Ctrl+XCut
Ctrl+YRepeat
Ctrl+ZUndo
F1Help
F2Edit
F3Paste Name
F4Repeat last action
F4While typing a formula, switch between absolute/relative refs
F5Goto
F6Next Pane
F7Spell check
F8Extend mode
F9Recalculate all workbooks
F10Activate Menubar
F11New Chart
F12Save As
Ctrl+:Insert Current Time
Ctrl+;Insert Current Date
Ctrl+”Copy Value from Cell Above
Ctrl+’Copy Formula from Cell Above
ShiftHold down shift for additional functions in Excel’s menu
Shift+F1What’s This?
Shift+F2Edit cell comment
Shift+F3Paste function into formula
Shift+F4Find Next
Shift+F5Find
Shift+F6Previous Pane
Shift+F8Add to selection
Shift+F9Calculate active worksheet
Ctrl+Alt+F9Calculate all worksheets in all open workbooks
Ctrl+Alt+Shift+F9Rechecks dependent formulas and then calculates all cells in all open workbooks
Shift+F10Display shortcut menu
Shift+F11New worksheet
Shift+F12Save
Ctrl+F3Define name
Ctrl+F4Close
Ctrl+F5XL, Restore window size
Ctrl+F6Next workbook window
Shift+Ctrl+F6Previous workbook window
Ctrl+F7Move window
Ctrl+F8Resize window
Ctrl+F9Minimize workbook
Ctrl+F10Maximize or restore window
Ctrl+F11Inset 4.0 Macro sheet
Ctrl+F12File Open
Alt+F1Insert Chart
Alt+F2Save As
Alt+F4Exit
Alt+F8Macro dialog box
Alt+F11Visual Basic Editor
Ctrl+Shift+F3Create name by using names of row and column labels
Ctrl+Shift+F6Previous Window
Ctrl+Shift+F12Print
Alt+Shift+F1New worksheet
Alt+Shift+F2Save
Alt+=AutoSum
Ctrl+Toggle Value/Formula display
Ctrl+Shift+AInsert argument names into formula
Alt+Down arrowDisplay AutoComplete list
Alt+’Format Style dialog box
Ctrl+Shift+~General format
Ctrl+Shift+!Comma format
Ctrl+Shift+@Time format
Ctrl+Shift+#Date format
Ctrl+Shift+$Currency format
Ctrl+Shift+%Percent format
Ctrl+Shift+^Exponential format
Ctrl+Shift+&Place outline border around selected cells
Ctrl+Shift+_Remove outline border
Ctrl+Shift+*Select the current region around the active cell.
Ctrl++Insert
Ctrl+-Delete
Ctrl+1Format cells dialog box
Ctrl+2Bold
Ctrl+3Italic
Ctrl+4Underline
Ctrl+5Strikethrough
Ctrl+6Show/Hide objects
Ctrl+7Show/Hide Standard toolbar
Ctrl+8Toggle Outline symbols
Ctrl+9Hide rows
Ctrl+0Hide columns
Ctrl+Shift+(Unhide rows
Ctrl+Shift+)Unhide columns
Alt or F10Activate the menu
Ctrl+TabIn toolbar: next toolbar
In a workbook: activate next workbook
Shift+Ctrl+TabIn toolbar: previous toolbar
In a workbook: activate previous workbook
TabNext tool
Shift+TabPrevious tool
EnterDo the command
Alt+EnterStart a new line in the same cell.
Ctrl+EnterFill the selected cell range with the current entry.
Shift+Ctrl+FFont Drop Down List
Shift+Ctrl+F+FFont tab of Format Cell Dialog box
Shift+Ctrl+PPoint size Drop Down List
Ctrl+SpacebarSelect the entire column
Shift+SpacebarSelect the entire row
CTRL+/Select the array containing the active cell.
CTRL+SHIFT+OSelect all cells that contain comments.
CTRL+\In a selected row, select the cells that don’t match the formula or static value in the active cell.
CTRL+SHIFT+|In a selected column, select the cells that don’t match the formula or static value in the active cell.
CTRL+[Select all cells directly referenced by formulas in the selection.
CTRL+SHIFT+{Select all cells directly or indirectly referenced by formulas in the selection.
CTRL+]Select cells that contain formulas that directly reference the active cell.
CTRL+SHIFT+}Select cells that contain formulas that directly or indirectly reference the active cell.
ALT+;Select the visible cells in the current selection.
SHIFT+BACKSPACEWith multiple cells selected, select only the active cell.
CTRL+SHIFT+SPACEBARSelects the entire worksheet.
If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region
When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet
Ctrl+Alt+LReapply the filter and sort on the current range so that changes you’ve made are included
Ctrl+Alt+VDisplays the Paste Special dialog box
Shortcut keyAction
Ctrl+ASelect All
Ctrl+BBold
Ctrl+CCopy
Ctrl+DFill Down
Ctrl+FFind
Ctrl+GGoto
Ctrl+HReplace
Ctrl+IItalic
Ctrl+KInsert Hyperlink
Ctrl+NNew Workbook
Ctrl+OOpen
Ctrl+PPrint
Ctrl+RFill Right
Ctrl+SSave
Ctrl+UUnderline
Ctrl+VPaste
Ctrl WClose
Ctrl+XCut
Ctrl+YRepeat
Ctrl+ZUndo
F1Help
F2Edit
F3Paste Name
F4Repeat last action
F4While typing a formula, switch between absolute/relative refs
F5Goto
F6Next Pane
F7Spell check
F8Extend mode
F9Recalculate all workbooks
F10Activate Menubar
F11New Chart
F12Save As
Ctrl+:Insert Current Time
Ctrl+;Insert Current Date
Ctrl+”Copy Value from Cell Above
Ctrl+’Copy Formula from Cell Above
ShiftHold down shift for additional functions in Excel’s menu
Shift+F1What’s This?
Shift+F2Edit cell comment
Shift+F3Paste function into formula
Shift+F4Find Next
Shift+F5Find
Shift+F6Previous Pane
Shift+F8Add to selection
Shift+F9Calculate active worksheet
Ctrl+Alt+F9Calculate all worksheets in all open workbook
Ctrl+Alt+Shift+F9Rechecks dependent formulas and then calculates all cells in all open workbooks
Shift+F10Display shortcut menu
Shift+F11New worksheet
Shift+F12Save
Ctrl+F3Define name
Ctrl+F4Close
Ctrl+F5XL, Restore window size
Ctrl+F6Next workbook window
Shift+Ctrl+F6Previous workbook window
Ctrl+F7Move window
Ctrl+F8Resize window
Ctrl+F9Minimize workbook
Ctrl+F10Maximize or restore window
Ctrl+F11Inset 4.0 Macro sheet
Ctrl+F12File Open
Alt+F1Insert Chart
Alt+F2Save As
Alt+F4Exit
Alt+F8Macro dialog box
Alt+F11Visual Basic Editor
Ctrl+Shift+F3Create name by using names of row and column labels
Ctrl+Shift+F6Previous Window
Ctrl+Shift+F12Print
Alt+Shift+F1New worksheet
Alt+Shift+F2Save
Alt+=AutoSum
Ctrl+Toggle Value/Formula display
Ctrl+Shift+AInsert argument names into formula
Alt+Down arrowDisplay AutoComplete list
Alt+’Format Style dialog box
Ctrl+Shift+~General format
Ctrl+Shift+!Comma format
Ctrl+Shift+@Time format
Ctrl+Shift+#Date format
Ctrl+Shift+$Currency format
Ctrl+Shift+%Percent format
Ctrl+Shift+^Exponential format
Ctrl+Shift+&Place outline border around selected cells
Ctrl+Shift+_Remove outline border
Ctrl+Shift+*Select current region
Ctrl++Insert
Ctrl+-Delete
Ctrl+1Format cells dialog box
Ctrl+2Bold
Ctrl+3Italic
Ctrl+4Underline
Ctrl+5Strikethrough
Ctrl+6Show/Hide objects
Ctrl+7Show/Hide Standard toolbar
Ctrl+8Toggle Outline symbols
Ctrl+9Hide rows
Ctrl+0Hide columns
Ctrl+Shift+(Unhide rows
Ctrl+Shift+)Unhide columns
Alt or F10Activate the menu
Ctrl+TabIn toolbar: next toolbar
Shift+Ctrl+TabIn toolbar: previous toolbar
Ctrl+TabIn a workbook: activate next workbook
Shift+Ctrl+TabIn a workbook: activate previous workbook
TabNext tool
Shift+TabPrevious tool
EnterDo the command
Alt+EnterStart a new line in the same cell.
Ctrl+EnterFill the selected cell range with the current entry.
Shift+Ctrl+FFont Drop Down List
Shift+Ctrl+F+FFont tab of Format Cell Dialog box
Shift+Ctrl+PPoint size Drop Down List
Sneltoetsen Visual Basic Editor
SneltoetsActie
F1Help
F2View Object Browser
F3Find Next
F4Properies Window
F5Run Sub/Form or Run Macro
F6Switch Split Windows
F7View Code Window
F8Step Into
F9Toggle Breakpoint
F10Activate Menu Bar
Shift+F2View definition
Shift+F3Find Previous
Shift+F7View Object
Shift+F8Step Over
Shift+F9Quick Watch
Shift+F10Show Right Click Menu
Ctrl+F2Focus To Object Box
Ctrl+F4Close Window
Ctrl+F8Run To Cursor
Ctrl+F10Activate Menu Bar
Alt+F4Close VBE
Alt+F6Switch Between Last 2 Windows
Alt+F11Return To Application
Ctrl+Shift+F2Go to last position
Ctrl+Shift+F8Step Out
Ctrl+Shift+F9Clear All Breakpoints
InsertToggle Insert Mode
DeleteDelete
HomeMove to beginning of line
EndMove to end of line
Page UpPage Up
Page DownPage Down
Left ArrowLeft
Right ArrowRight
Up ArrowUp
Down ArrowDown
TabIndent
EnterNew Line
BackSpaceDelete Prev Char
Shift+InsertPaste
Shift+HomeSelect To Start Of Line
Shift+EndSelect To End Of Line
Shift+Page UpSelect To Top Of Module
Shift+Page DownSelect To End Of Module
Shift+Left ArrowExtend Selection Left 1 Char
Shift+Right ArrowExtend Selection Right 1 Char
Shift+Up ArrowExtend Selection Up
Shift+Down ArrowExtend Selection Down
Shift+TabOutdent
Alt+SpacebarSystem Menu
Alt+TabCycle Applications
Alt+BackSpaceUndo
Ctrl+ASelect All
Ctrl+CCopy
Ctrl+EExport Module
Ctrl+FFind
Ctrl+GImmediate Window
Ctrl+HReplace
Ctrl+ITurn On Quick Info
Ctrl+JList Properties/Methods
Ctrl+LShow Call Stack
Ctrl+MImport File
Ctrl+NNew Line
Ctrl+PPrint
Ctrl+RProject Explorer
Ctrl+SSave
Ctrl+TShow Available Components
Ctrl+VPaste
Ctrl+XCut
Ctrl+YCut Entire Line
Ctrl+ZUndo
Ctrl+InsertCopy
Ctrl+DeleteDelete To End Of Word
Ctrl+HomeTop Of Module
Ctrl+EndEnd Of Module
Ctrl+Page UpTop Of Current Procedure
Ctrl+Page DownEnd Of Current Procedure
Ctrl+Left ArrowMove one word to left
Ctrl+Right ArrowMove one word to right
Ctrl+Up ArrowPrevious Procedure
Ctrl+Down ArrowNext Procedure
Ctrl+SpacebarComplete Word
Ctrl+TabCycle Windows
Ctrl+BackSpaceDelete To Start Of Word
Ctrl+Shift+IParameter Info
Ctrl+Shift+JList Constants