PhpStorm 2018.3 Help

Working with cells

Basic operations with cells

You can modify values in the table cells and, if appropriate, upload files.

Action

Shortcut

Description

Edit

F2

Edit a cell value. Alternatively, select a cell and start typing a new value. To confirm your changes, press Enter.

Edit Maximized

Shift+Enter

Expands a cell for editing. To confirm your changes, press Ctrl+Enter.

Add a new line

Ctrl+Enter

Adds a new line in the regular editing mode (F2).

Revert selected

Ctrl+Alt+Z

Restores the previous cell value.

Maximize

Ctrl+Shift+Alt+M

Expands the selected cell.

Add a new line in a maximized cell

Enter

Adds a new line in the maximized editing mode (Shift+Enter). To confirm your changes, press Ctrl+Enter.

Set the default value

Ctrl+Alt+D

Sets the current cell value to the default value.

Set the NULL value

Ctrl+Alt+N

Sets the current cell value to the NULL value.

Load file

Uploads a file into the field. Right-click a cell and select Load File.

Edit as

F2 or Shift+Enter

Edit a value in the cell as a fragment of SQL, HTML, XML, or any other supported language.

Edit a value in the cell as a fragment of a supported language

Value completion

Ctrl+Space

Opens the suggestion list. To invoke value completion, start editing the cell and press Ctrl+Space. The list contains values from the current column that match your input.

Adding cells with the same contents to the selection

Alt+J

Adds the nearest cell with the same contents to the selection. To remove a cell from the selection, press Shift+Alt+J.

Expand a selection from a cell to a table

Ctrl+W

Expands a selection from a cell to a table.

  • Press one time: the selection expands to a column.

  • Press two times: the selection switches from the column to a row.

  • Press three times: the selection expands to the whole table.

Compare cells

Ctrl+Shift+D

Compares the contents of two or three cells within one table. Select up to three cells and press Ctrl+Shift+D. Alternatively, right-click the selection and select Compare Cells.

Compare cells

Using the quick documentation view

The quick documentation view provides details about values in the selected cell or cells. For example, if a cell contains long text, you will see the whole text. If a cell contains an image, you will see a preview of the image. Also, you can see records that are referenced in the current record as well as the records that reference the current one.

Object

Documentation view

Long text

If a cell contains long text, you will see the whole text.

Quick documentation view for long texts

Image

If a cell contains an image, you will see a preview of the image.

Quick documentation view for images

Records

The quick documentation view for records displays records that are referenced in the current record and records that reference the current one.

Quick documentation view for an image

You can switch to the transposed view. In the transposed view, rows and columns are interchanged.

To switch to the transposed view, click Transposed View. For more information about the transposed view, see .

Transposed view for records

Edit multiple cell values simultaneously

  1. Select a range of cells that you want to edit.

  2. Start typing a new value. The changes are applied to all the selected cells.

  3. To confirm the value, pressEnter. To cancel editing, pressEscape.

Saving a LOB in a file

You can save a binary large object (BLOB or LOB) from a cell into a file.

  1. Right-click the cell that contains the LOB and select Save LOB.

  2. In the save dialog, specify the name and location of the file and click OK.

Last modified: 22 January 2019