Overview  

Prerequisites  

1. If pasting data from Zoho Sheet, you’ll need access to the source sheet for linking.
   

How-tos  

1. Insert a new table  

1. Go to the Insert tab > Table, and pick the number of rows and columns.
   
2. Alternatively: type =table(m,n) (for example =table(3,4) for 3 rows × 4 columns) and press Enter.
   

2. Insert a spreadsheet

1. To insert a spreadsheet as a table: Go to the Insert tab> Table > Insert a new spreadsheet.
   
   
2. To paste a Zoho Sheet data range and link it: Click the paste icon in the inserted table and choose Link data with the source.
   
   
   
3. Click the icon near the table to update the table data, to unlink the table from Sheet, or to open the source sheet right away. You can also change the cell range, as required.
   
4. Update the table data by clicking on the Update option. Any changes made to sheet data will be updated in the table every time you click on the Update option.
   

3. Convert text to table  

1. Separate text by lines (for rows) and by tabs/commas/dashes (for columns).
   
2. Go to the Tools tab > Text to Table.
   
3. In the Convert text to table dialog that pops up, configure the desired settings, and click OK.
   

4. Add/delete rows or columns  

1. Click the table, and open the Table Options panel by clicking the gear icon.
   
2. Under Layout > Rows and Columns, choose to add or delete rows/columns.
   
3. You can also add or delete rows from the right click menu.
   

5. Merge or split cells  

1. To merge: select the cells > gear icon > Layout > Merge Cells.
   
2. To split: click a cell > gear icon > Layout > Split Cells.
   

6. Adjust layout (row height / column width / margins)  

1. Gear icon > Layout: modify row height or column width.
   
2. For equal distribution: gear icon > Layout > Distribute Rows / Columns.
   
3. To change cell margins: gear icon > Cell Properties > Custom Margins.
   

7. To vertically align text inside a table cell  

1. Select the text inside the desired table cell.
   
2. Click the gear icon (⚙️) to open Table Options.
   
3. Go to Cell Properties > Text Align.
   
4. Choose your preferred vertical and horizontal alignment option.
   
   
   

8. Set header row(s) & control page breaks  

1. To repeat header row on new pages: gear icon > enable Use first row as header.
   
2. To mark multiple header rows: gear icon > Mark first (number) row(s) as header. Alternatively, select the rows you want to set as headers and Set header up to this row from the visual cue.
   
3. To prevent rows or tables from breaking across pages: gear icon > disable Allow row to break across pages, or Allow table to break across pages respectively.
   
   
   

9. Table utilities  

1. Split table: select table > right-click > More options > Split table.
   
2. Transpose table (swap rows ↔ columns): select table > right-click > More options > Transpose table.
   
3. Convert table to text: right-click table > More options > Convert Table to Text. Choose separator format (tabs, commas, paragraphs).
   
4. Convert table to chart: select table > right-click > More options > Convert table to chart.
   
   

10. Sort table data  

1. Select table > gear icon > Sort Table under Rows and Columns.
   
2. Choose ascending or descending based on a column; if header row exists, enable Consider first row as table header.
   

11. Design table (themes, borders, shading)  

1. Select table > click Table icon > Table Themes panel; pick a preset or custom color.
   
2. To customize borders and background: gear icon > Borders and Shadings. Options include sides, color, width (up to 10px), style, remove border, cell background color or image.
   
   
   

12. Use formulas in table cells  

1. Click the cell > Formula icon (or gear icon > Formula).
   
2. Enter a formula or pick one from list (e.g., SUM, AVERAGE, IF, COUNT, MAX, MIN, PRODUCT, etc.). Use cell references or keywords like LEFT, ABOVE.
   
3. Choose number format if needed; press OK, then refresh/press F9 for results.
4. Formulas work with Mail Merge and are preserved when importing/exporting MS Word.
   

13. Delete a table  

1. Right-click on the table > Delete Table.
   

Troubleshooting  

1. Enable (¶) in the Format pane to check for hidden paragraph breaks.
   
2. Delete any additional paragraph breaks below the text inside the cell.
   
3. Set both Before and After paragraph spacing to 0 pt from Format > More under Paragraph.
4. Reapply the desired vertical and horizontal alignment or reload the document, all options should now work as expected.

Related Articles  

1. Formula in Writer
   
2. Group-by and Aggregate Fields in Zoho Writer
   
3. Watch: Webinar on tables in Writer