Using Advanced Table Options

Once you’ve created and formatted your table, you can use advanced options to work with the table. This article shows you how to get the most out of your tables.

Using Table Focus Mode

To work in Table Focus mode, click on the Table Options icon in the upper-left corner and select Enter Table Focus Mode.

image alt text

Working in Table Focus mode expands your view of the table by temporarily hiding the rest of the document. You can exit Table Focus mode from the Table Options menu. Note that other options including Select Table, Clear Table, Delete Table, Table Properties and Insert Table Title are also available from this menu.

Locking Cells

Locking selected cells prevents inadvertent changes to data, including changes to the formatting. Locked cells can be identified by their grayed-out contents. Only a Document Owner can lock or unlock cells. Table and workbook cells can be locked or unlocked by selecting the cell(s) and then choosing Lock Selection or Unlock Selection from the Edit tab. Both formula and non-formula cells can be locked.

image alt text

Locking source cells will prevent changing the value of all destination links. Locking cells will prevent links from inadvertently being removed. Locking only a destination cell will still allow for the value of that cell to be changed at the source. Changes cannot be pasted over locked cells.

Additionally, tracked changes made before a cell was locked can be accepted but not rejected.

Rows, columns, or tables containing locked cells cannot be deleted. If you try to delete a locked cell, a warning will appear and you will be prevented from doing so.

NOTE: XBRL tagging can still be performed on locked cells.

Creating Table Breaks

You may not know exactly where a table will break across pages until all text has been completed and the document is finalized. This makes it important to know how to work with tables across page breaks in a number of ways.

If you have a preference for where you would like the table to break across pages, you can right-click on a row to access Row Properties. Then check the box for the location where you’d prefer the table to break. Click Apply.

image alt text

Depending on the final layout of your document, the page will break after this row if necessary. If you have more than one preferred pagebreak set, the application will fit the maximum amount of the table on the page. Rows with preferred page breaks can be identified by italicized row numbers.

Copying Column Widths and Row Heights

You can also copy and paste column widths and apply them to multiple tables for faster table setup and formatting. On a table with the set column widths, right-click in the column header and select Copy All Column Widths. You can also do this with a selection of columns rather than the entire table.

Right-click in the column header on the table you'd like to paste the column widths to and choose Apply Column Widths. This function will only copy the existing column widths; and will only apply to the number of existing columns based on the copied table. Apply column widths will not copy any data or apply any cell formatting.

This process can also be applied to rows, using the Copy All Row Heights option in the right-click menu. As with columns, right-click the table with the desired row heights and select the option, then right-click the target to apply the new row heights and choose Apply Row Heights.