Launch spreadsheet
Top navigation bar
Open a spreadsheet from the links on the app screen (Top navigation bar > Apps > Spreadsheets).
Project sidebar
Open a spreadsheet from the links on the project page (project sidebar > Spreadsheets).
Issue navigator
Open a spreadsheet from the edit button on Jira Issue Navigator (Top navigation bar > Issues).
Edit fields on spreadsheet
Inline editing
If some fields are grayed out and cannot edit, please see the articles of Excel-like Issue Editor for Jira: Knowledge base and workarounds.
Start editing a cell with double-click or F2 or click pencil icon.
| Double-click or press "F2" to edit |
|---|
 |
Copy and paste
Copy the value of selected cells.
Copy (CTRL+C/Windows or CMD+C/MacOS) | Mouse select | Paste (CTRL+V/Windows or CMD+V/MacOS) |
|---|---|---|
|
|
|
Save
| Click "Save" or shortcut (CTRL+S/Windows or CMD+S/MacOS) |
|---|
 |
Revert
| After selecting cells, Revert (CTRL+Z/Windows or CMD+Z/MacOS) | Changes discarded |
|---|---|
|
|
Columns
Change the configuration on Issue Navigator. Please see the article of Excel-like Issue Editor for Jira: Knowledge base and workarounds.
Operations bar
Search
Input a keyword and Enter |
|---|
|
You can use shortcut (CTRL+F/Windows or CMD+F/MacOS) to move focus on the search box.
Hierarchy View
That hierarchy view function is to display Jira's subtask, Epic Link of Jira Software and Parent-child relationship of WBS Gantt-Chart for Jira.
Display all issues | Click the hierarchy button |
|---|---|
|
|
Back to Jira
You can return to the location where you launched the spreadsheet.
Other functions
Excel-like Issue Editor provides the other functions via the cog icon menu.
Databar Number
Visualize the values of number fields.
Format Timetracking Fields
Change the display format of timetracking fields.
Freeze Columns
Select a cell and freeze up to the current column.
Sort and filter
Display all issues | Click column header |
|---|---|
|  |
Context Menu
Right-click on the row number.
View issue
Open view issue screen.
Expand all
Expand all collapsed rows under hierarchy view mode.
Copy issue
Copy selected issue.
This function is similar to "Clone", but actually creates a new issue.
Create child
Create one child issue under hierarchy view mode.
Delete issue
Delete selected issue.
Drag and drop
You can change parents in "Hierarchy View".
Cross-hair-cursor will display over the top or bottom of the grid line.
Select the row | Drag cross-hair-cursor |
|---|---|
|
|
