Search
CTRL+F
Display the Find dialog box
CTRL+H
Display the Replace dialog box
CTRL+B
Start incremental search. Type the characters to search for or press CTRL+I to search for characters from the previous search
F3
Find the next occurrence of the previous search text
SHIFT+F3
Find the previous occurrence of the search text
CTRL+F3
Find the next occurrence of the currently selected text
CTRL+SHIFT+F3
Find the previous occurrence of the currently selected text
CTRL+SHIFT+H
Display the Replace in Files dialog box
CTRL+SHIFT+I
Reverse incremental search so it starts at the bottom of the file and searches to the top
ALT+F3. B
Select or clear the Search up option in Find and Replace
ALT+F3. S
Stop the Find in Files search
ALT+F3. W
Select or clear the Find whole word option in Find and Replace
ALT+F3. P
Selects or clears the Wildcard option in Find and Replace
Menu Activation
ALT
Move to the SQL Server Management Studio menu bar
ALT+HYPHEN
Activate the menu for a tool component
SHIFT+F10
Display the context menu
CTRL+SHIFT+N
Display the New Project dialog box to create a new project
CTRL+SHIFT+INS
Display the Open File dialog box to open an existing file
CTRL+SHIFT+Q
Display the Query Designer
ESC
Close a menu or dialog box. canceling the action
Windows Management and Toolbar
CTRL+F4
Close the current MDI child window
SHIFT+ALT+ENTER
Toggle full screen mode
SHIFT+ESC
Close the current tool window
CTRL+TAB
Cycle through the next MDI child windows
CTRL+SHIFT+TAB
Cycle through the previous MDI child windows
ALT+F6
Move to the next tool window
SHIFT+ALT+F6
Move to the previously selected window
CTRL+O
Opens a new query editor window
F8
Display Object Explorer
CTRL+ALT+T
Display Template Explorer
CTRL+ALT+L
Display Solution Explorer
F7
Display the Summary Window
F4
Display the Properties Window
CTRL+ALT+X
Display the Toolbox
CTRL_ALT+R
Display the Browser Window
Cursor Movement
LEFT ARROW
Move the cursor left
RIGHT ARROW
Move the cursor right
UP ARROW
Move the cursor up
DOWN ARROW
Move the cursor down
HOME
Move the cursor to the beginning of the line
END
Move the cursor to the end of the line
CTRL+HOME
Move the cursor to the beginning of the document
CTRL+END
Move the cursor to the end of the document
PAGE UP
Move the cursor up one screen
PAGE DOWN
Move the cursor down one screen
CTRL+RIGHT ARROW
Moves the cursor one word to the right
CTRL+LEFT ARROW
Moves the cursor one word to the left
Text Selection
CTRL+SHIFT+HOME
Select text from the cursor to the beginning of the document
CTRL+SHIFT+END
Select text from the cursor to the end of the document
SHIFT+HOME
Select text from the cursor to the start of the current line
SHIFT+END
Select text from the cursor to the end of the current line
SHIFT+DOWN ARROW
Select text down line by line starting from the cursor
SHIFT+UP ARROW
Select text up line by line starting from the cursor
SHIFT+ALT+UP ARROW
Move the cursor up one line. extending the selection
SHIFT+PAGE UP
Extend selection up one page
SHIFT+PAGE DOWN
Extend selection down one page
CTRL+A
Select the entire current document
CTRL+W
Select the word containing the cursor. or the closest word
CTRL+=
Select the current location in the editor. back to the previous location in the editor
CTRL+SHIFT+PAGE UP
Extend the selection to the top of the current window
CTRL+SHIFT+PAGE DOWN
Move the cursor to the last line in view. extending the selection
CTRL+SHIFT+RIGHT ARROW
Extend the selection one word to the right
CTRL+SHIFT+LEFT ARROW
Extend the selection one word to the left
CTRL+SHIFT+ALT+RIGHT ARROW
Move the cursor to the right one word. extending the selection
CTRL+SHIFT+ALT+LEFT ARROW
Move the cursor to the left one word. extending the selection
Bookmark
CTRL+F2
Set or remove a bookmark at the current line
SHIFT+F2
Previous bookmark
CTRL+SHIFT+F2
Clear bookmarks
Tree Control
- (on the numeric keypad)
Collapse tree nodes
* (on the numeric keypad)
Expand all tree nodes
CTRL+UP ARROW
Scroll the tree control up in the window
CTRL+ DOWN ARROW
Scroll the tree control down in the window
Code Editor
SHIFT+ALT+ENTER
Toggle the full-screen display
CTRL+UP ARROW
Scroll text up one line
CTRL+DOWN ARROW
Scroll text down one line
CTRL+Z
Reverse the last editing action
CTRL+SHIFT+Z or CTRL+Y or ALT+SHIFT+BACK SPACE
Restore the previously undone edit
CTRL+SHIFT+P
Insert the body of the specified file into the current window.
CTRL+S
Save the selected item
CTRL+SHIFT+DEL
Delete all text in the current file
CTRL+G
Display the Go To Line dialog box
SHIFT+TAB
Decrease line indent
CTRL+SHIFT+U
Make the selected text upper case
CTRL+SHIFT+L
Make the selected text lower case
CTRL+SHIFT+C
Make the selected text a comment
CTRL+SHIFT+R
Uncomment the selected text
CTRL+N
Open a new query with current connection
ALT+F8
Open database in Object Explorer
CTRL+SHIFT+M
Specify values for template parameters
F5 or CTRL+E or ALT+X
Execute the selected portion of the query editor or the entire query editor if nothing is selected
CTRL+F5
Parse the selected portion of the query editor or the entire query editor if nothing is selected
CTRL+L
Display the estimated execution plan
ALT+BREAK
Cancel the executing query
CTRL+K
Include actual execution plan in the query output
CTRL+SHIFT+O
Open the Query Option dialog box
CTRL+D
Output results in a grid
CTRL+T
Output results in text format
CTRL+SHIFT+F
Output results to a file
CTRL+R
Show or hide the query results pane
F6
Toggle between query and results pane
CTRL+F6
Move to the next active window in Management Studio
Text Manipulation in Code Editor
ENTER or SHIFT+ENTER
Insert a new line
DELETE
Delete on character to the right of the cursor
BACKSPACE or SHIFT+BACKSPACE
Delete one character to the left of the cursor
TAB
Insert the number of spaces configured for the editor
CTRL+ENTER
Insert a blank line above the cursor
CTRL+SHIFT+ENTER
Insert a blank line below the cursor
CTRL+SHIFT+L
Change the selected text to lowercase
CTRL+SHIFT+U
Change the selected text to uppercase
INSERT
Toggle between insertion mode and overtype mode
SHIFT+TAB
Move selected lines to the left on tab stop
CTRL+DELETE
Delete the word to the right of the cursor
CTRL+BACKSPACE
Delete the word to the left of the cursor
CTRL+SHIFT+T
Transpose the words on either side of the cursor
Microsoft IntelliSense
ALT+RIGHT ARROW
Complete word
Document Window and Browser
SHIFT+ALT+ENTER
Toggle full-screen mode
F6
Move to the next pane of a split pane view of a document
CTRL+SHIFT+F6/CTRL+SHIFT+TAB
Move to the previous document in the editor or designer
SHIFT+F6
Move to the previous pane of a document in split pane view
CTRL+ALT+R
Display the Browser Window
ALT+LEFTARROW
Back. display the previous page in the viewing history
ALT+RIGHTARROW
Forward. display the next page in the viewing history
Solution Explorer
CTRL+ALT+L
Display Solution Explorer
CTRL+SHIFT+INS
Display the New File dialog box to create a new file
CTRL+SHIFT+N
Display the New Project dialog box to create a new project
Help and Books Online
CTRL+F1
"Help on ""How Do I"""
CTRL+ALT+F1
Books Online Contents
CTRL+ALT+F2
Books Online Index
CTRL+ALT+F
Help Favorites
Cut and Paste
CTRL+X or SHIFT+DELETE
Cut (delete the currently selected item and place it to the Clipboard)
CTRL+C or CTRL+INSERT
Copy to the Clipboard
CTRL+V or SHIFT+INSERT
Paste from the Clipboard at the insertion point
Log Viewer
F6
Move between the Select logs pane and the Log file summary pane
ALT+S
Move to the Log file summary pane
CTRL+SHIFT+L
Load a new log
CTRL+SHIFT+E
Export a log
CTRL+SHIFT+F
Filter a log
CTRL+SHIFT+S
Search in a log
Activity Monitor
CTRL+SHIFT+F
Filter the monitor display
Replication Monitor
ENTER
Open a detail window from a grid
Replication Conflict Viewer