Common questions about Sheet Tools usually involve display, page breaks, conversion, and layout settings; this FAQ covers 5 frequent questions and practical fixes.
FAQ
What should I do if table content is not fully visible?
- Select the table.
- Open AutoFit in Table Tools.
- Choose AutoFit to Contents, or manually drag row and column borders.
- Check again whether the text in each cell is fully visible.
Why are header rows not repeated after a table moves to the next page?
- Select the row or rows used as the header.
- Open Table Tools.
- Click Repeat Header Rows.
- Preview the page layout and confirm that the header appears at the top of each page.
Why does table content look cut off at page breaks?
- Select the table and right-click to open Table Properties.
- Switch to the Row tab.
- Select Allow row to break across pages.
- Confirm the setting and review the page layout again.
How do I convert a table into plain text?
- Select the table that you want to convert.
- Open Table Tools.
- Click Convert to Text.
- Choose a separator such as a tab, comma, or paragraph mark, then confirm.
Why does the content stay in place after I use Eraser?
- Make sure you are using the Eraser tool.
- Note that this tool is used to remove border lines.
- If you want to delete text, select the text itself and delete it.
- If you want to remove table structure, use Delete Cell or another delete command.
Glossary
| Term | Definition |
|---|---|
| Repeat header rows | A feature that shows the same header row at the top of each page when a long table spans multiple pages. |
| Row break across pages | A setting that controls whether a table row can split at a page break. |
| Merge cells | An action that combines adjacent cells into one larger cell. |
| Convert to Text | A feature that changes table content into plain text based on a selected separator. |
| Eraser | A tool that removes table border lines to adjust the table structure visually. |