Data Editor shortcuts

Last modified: September 30, 2024

Use the following shortcut key combinations when working with data in Data Editor or in the Data Viewer of a SQL document in Data Compare for SQL Server.

Command Name	Shortcut Keys	Action
AutoSearchMode	CTRL+I	Enable the auto-search mode
CopyWithHeader	CTRL+SHIFT+C	Copy data with the column header
DeleteRow	CTRL+DELETE	Delete the currently selected row in the data grid
FilterEqual	CTRL+Q	Quick filtering by equal value
NewRow	INSERT	Insert a new record into the grid
RefreshData	F5	Refresh the data view
RefreshData	CTRL+R	Refresh the data view
SelectColumn	CTRL+SPACE	Select the entire column in the grid
SelectRow	SHIFT+SPACE	Select the entire row in the grid
SetToNull	CTRL+0	Insert a NULL value into the current cell
SetToNull	CTRL+NUMPAD 0	Insert a NULL value into the current cell
ShowDataViewer	CTRL+W, R	Open the Data Viewer
SaveData	CTRL+S	Save data in the Data Viewer
CopyData	CTRL+C	Copy data in the Data Viewer
HexadecimalView	CTRL+1	Represents data in a hexadecimal view
TextView	CTRL+2	Represents data in a text view
XMLView	CTRL+3	Represents data in an XML view
HTMLView	CTRL+4	Represents data in an HTML view
WebView	CTRL+5	Represents data in a web view
RichTextView	CTRL+6	Represents data in a rich text view
PDFView	CTRL+7	Represents data in a PDF view
JSONView	CTRL+8	Represents data in a JSON view
ImageView	CTRL+9	Represents data in an image view
FitImage	Ctrl+B	Scales images to fit the window
SpatialView	Ctrl+Alt+0	Represents data in a spatial view

The default keyboard mapping scheme for the shortcuts above is Microsoft SQL Server Management Studio. It can be changed in the Tools menu > Options > Environment > Keyboard > Apply the following additional keyboard mapping scheme. Whenever you change the scheme, the shortcuts will be changed accordingly.