Working with TablesLast updated on 06/13/19
Once you’ve inserted your table, you can use the advanced options to work with the table. This article shows you how to get the most out of your tables.
Merging and Splitting Table Cells
To merge cells in a table:
- Select the cells you want to merge.
- Right-click the cells and select Merge Cells from the drop-down menu.
- Select how you want to merge the cells.
- Merge All combines cells across both rows and columns.
- Merge Horizontally combines the cells into single rows.
- Merge Vertically combines the cells into single columns.
Note: Merging cells across multiple rows and cells at once retains only the information in the top-left cell.
To split a cell or range of cells in a table into multiple cells:
- Select the cell(s) you want to split.
- Right-click the cells and select Merge Cells.
- Choose Unmerge from the drop-down menu.
Hiding Rows and Columns
Rather than deleting a column or row that may be needed at a later date, you can hide them from the current view using the Hide Rows and Columns feature. This saves you from needing to relink and retag those cells.
To hide a row or column:
- Right-click the header of the column or row.
- Select Hide from the drop-down menu.
To unhide a row or column:
- Right-click any header in the table.
- Select Unhide from the drop-down menu.
- Select the row or column to unhide. If you’d like to reveal all hidden columns, select All Columns.
Locking selected cells prevents changes to data, including changes to the formatting. Only a Document Owner can lock or unlock cells. Locking only a destination cell will still allow for the value of that cell to be changed at the source.
Note: Only Document Owners can lock and unlock cells.
To lock a table or cells:
- Select the cell(s).
- From the Edit tab, click the Lock icon. Rows, columns, or tables containing locked cells cannot be deleted.
To unlock a table or cells, select the cells again and click the Unlock icon.
Note: You can still tag XBRL on locked cells.