Creating tables
Tables are an efficient way to present information. It will save the writer the time and space needed to explain the relationships between discrete data points and allow the reader to access a more comprehensive body of information. Writer offers a range of tools board and features to expedite the process of creating information-rich documents.
Insert new table
To create a table,
- Click More
> Insert tab.
- Under Pictures & Tables, click Table.
- Select the number of rows and columns required for the table. A table with a defined size will be created.

Insert a quick table
You can insert a quick table into your document by typing the number of rows (m) and the number of columns (n) in the formula =table(m,n) and hitting Enter. For example, if you want a table that has three rows and four columns, type =table(3,4) and hit Enter.

Insert spreadsheet as a table
Writer integrates with Sheet, which lets you create spreadsheets within your documents. You can insert, edit, and format spreadsheets, or work with advanced formulas without leaving Writer.
To insert a table as a spreadsheet,
- Click More
> Insert tab.
- Under Pictures & Tables, click the drop-down near Table and choose Insert New Spreadsheet.

Paste spreadsheet as a table
You can easily copy/paste data from Zoho Sheet within your Writer documents.
While pasting the data from Zoho sheet, you can link the source sheet to the table directly.
To link the source sheet to your table,
- Copy/paste the sheet data from Zoho Sheet in your Writer document.
- Click the
icon near the Table pasted from Zoho Sheet and choose the "Link data with the source" option.

- 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.
- 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.

Convert text to table
For example, if you have a long list of items that have to be formatted as a table, but currently it is written as a list. Use the 'convert text to table' option to simply convert this list into a table. Also, if you do not have the time to create a table and make entries in it, type the entries as text and then convert it to a table in just a few clicks.
To convert a piece of text into a table,
- Separate text with lines or paragraphs (for rows) and commas, tabs, or dashes (for columns).
- Select the text that you want to convert to a table.
- Click More
> Tools.
- Under Editing, click the Text to table option. Choose the required settings on how you want the table to appear.
- Click OK. The text will be placed within a table.

Table operations
Add or delete rows and columns
To add/delete rows and columns,
- Click on the table.
- Click the gear-shaped
icon near the inserted table. The Table Options panel will appear on the left side of the screen.

- Go to the Layout tab. Under the Rows and Columns header, you will find options to add or delete rows and columns.

Split cells
You can split a cell if you want two separate entries in it.
To split cells in a table,
- Click the cell you want to split.
- Click the gear-shaped
icon near the inserted table to open the Table Options panel.

- Under the Layout tab, click the Split Cells
icon.

Merge cells
If you want to enter a word or title covering multiple rows or columns, you can merge cells and do it.
To merge cells,
- Click on the table and select the cells you want to merge.
- Click the gear-shaped
icon near the inserted table to open the Table Options panel.

- Under the Layout tab, click the Merge Cells
icon.

Table layout
Set row height and column width
You can adjust the row height and column width of your table if it looks too packed or imprecise.
To change row height and column width,
- Click the gear-shaped
icon near the inserted table to open the Table Options panel.

- Enter the dimensions for row height and column width under Layout > Rows and Columns.

Distributing rows and columns
If you want columns of equal size across your table, you can use this option.
To distribute columns equally across a table,
- Click the gear-shaped
icon near the inserted table to open the Table Options panel.

- Click Distribute Rows or Distribute Columns under Rows and Columns header.

Set cell margins
Cell margins surround the text within a cell at the left, right, top, and bottom sides. You can customize cell margins to adjust the placement of the text within a cell.
To customize cell margins,
- Click the gear-shaped
icon near the inserted table to open the Table Options panel.

- Change the cell margins under the Cell Properties header. Also, click Custom Margins option and set dimensions to the table cells based on your requirements.

If the table moves to more than one page in a print layout, enable the "Use first row as header" option to automatically repeat the table header at the beginning of every new page.
To create a table header row,
- Click the gear-shaped
icon near the inserted table to open the Table Options panel.

- Under the Rows and Columns header, enable the "Use first row as header" checkbox.

Setting Multiple Table Rows as Headers
You can now designate multiple rows as headers within a table to organize data in a hierarchical structure. Follow the steps below to set multiple rows as headers:
Method 1: Using the Table Options Panel
- Click inside any cell of the table.
- On the left panel, click Table to open the Table Options.
- In the Rows and Columns section, enable Mark first (number) row(s) as header.
- Enter the number of rows you want to set as headers or use the spinner to adjust the number. For instance, entering 3 here will make the first three rows header. The selected rows will now be marked as headers.
Method 2: Using the Visual Cue from the Editor
- Click inside any cell of the table.
- A visual cue with table settings will appear.
- Select the rows you want to set as headers. For instance, selecting three rows here will make them the header.
- Click Select header up to this row from the visual cue. The headers will be applied up to the selected row.
Method 3: Using the Right-Click Menu
- Select the cells up to which you want the headers.
- Right-click to open the context menu.
- Select More Options > Select header up to this row. The headers will be applied to the selected rows.
You can remove table headers partially or completely using any of the methods mentioned:
- Table Options Panel: Disable the Mark first (number) row(s) as header option to remove headers completely. You can also decrement the number entered to remove headers partially. For example, changing the number from 3 to 2 will remove the third row from the header.
- Visual Cue: Select the rows you want to remove and click Remove header from the visual cue.
- Right-Click Menu: Select the rows you want to remove and right-click. In the panel, navigate to More Options and select Remove header.
Handling row breaks across pages
The information in each table row can either be split across pages or stay together in one page.
To enable/disable row breaks across pages,
- Click the gear-shaped
icon near the inserted table to open the Table Options panel.

- Enable/disable the Allow rows to break across pages check box, based on your requirements. For example, if the table moves to more than one page, you can disable this option, so that the content in each table row stays together in one page, thus providing better readability.

Table utilities
Writer allows you to split your table to two or more tables, convert rows to columns and vice versa, convert your table to text, convert tables to charts, and much more. Here's how you do it.
Split tables
To split the table,
- Select your table.
- Right-click on any cell where you want to split your table.
- Click More options > Split table.
Break rows and tables
The Allow row/table to break across pages option in Zoho Writer allows you to control whether a row or table can break across pages. By default, this option is enabled, which means that rows and tables can break across pages if necessary. However, you can disable this option to prevent rows and tables from breaking across pages. This applies to a table inserted inside Table of Contents and a table inside a table too.
Steps
- To prevent a row or table from breaking across pages, follow these steps:
- Select the row or table that you want to change.
- In the Table Options that open on the left pane, find "Table Properties"
- To prevent a row from breaking across pages, clear the Allow row to break across pages check box.
Transpose tables
Sometimes, data can be more meaningful or easier to analyze when presented in a different orientation. Transpose tables allow you to reorganize data from rows to columns or vice versa. This can be helpful when you want to perform calculations, create charts, identify trends in your data, or present data in a different format without having to rearrange each cell manually.
To transpose a table,
- Place the cursor on your table.
- Right-click on your table, click More options > Transpose table.
Convert table to text
Convert a table in your Writer document to text. You can customize the conversion to text by selecting your preferred format, such as paragraphs, tabs, commas, or any other symbol or separator according to your preference.
To convert a table to text,
- Place the cursor on your table.
- Right-click on your table, click More options > Convert Table to Text.
- Select your preferred conversion format, such as paragraphs, tabs, commas, or other separators, and click Ok. Your table is now converted into text.
Convert table to chart
Transform your table into charts in Writer.
To convert a table to chart,
- Select your table.
- Right-click on your table, click More options > Convert table to chart.

Handy mouse clicks to work with tables
When you work with tables, especially the ones that are long, you will find these handy mouse clicks make things around tables easier than ever.
- Clicking on the individual cells will let you both select/deselect them.
- To select an entire column of cells, position the mouse at the top of the row that needs to be selected. A bottom headed arrow mark will appear. Click on it to select the entire row
- Toselect an entire row of cells,place the cursor at the leftmost margin of the table whose columns are to be selected. A right-headed-arrow mark will appear. Now, click on it for the entire column to be selected.
- Toselect multiple random cells,select the first cell, press Ctrl and then select other cells.
- To resize an entire table, place your cursor on the tiny-square-box at the bottom-right corner of the table. Clicking on it will enable you to drag the table both in the horizontal and the vertical direction, thereby allowing you to resize the entire table.

Move table
Drag and drop a table anywhere in your document.
To move the table,
- Click on the table.
- Click
icon and drag to move your table anywhere within your document.

Table Sorting
You might need to sort the table to enhance and understand the data in a better way. For example, when you have to review the list of employees joined and prefer to view the names in alphabetical order or by the department. You can use the sort table option and sort according to the entries in any specific column of the table. Sorting in ascending order arranges text in alphabetical or sequential order from lowest to highest. (A –> Z or 0 –> 9). If you are sorting in descending order, the data is arranged from highest to lowest (Z –> A or 9 –> 0).
To sort a table,
- Select the table.
- Click the gear-shaped
icon near the inserted table to open the Table Options panel.
- Click Sort Table under the Rows and Columns header of the Table Options panel. The Sort Table pop-up will open.
- You can sort in either ascending or descending order. Choose a column and sort it based on numbers or text. Enable the 'Consider first row as table header' checkbox to sort the column data excluding the header.
- Once the above changes are done, click Sort.

Table design
Table themes
To change the theme and color of your table,
- Select your table and click on the Table icon near the inserted table. The Table Themes panel will open.
- Choose the required theme from the available list. You can mouse hover on each theme and have a view on how your table looks before you apply them. Also, you can just customize the table color from the color palette, if you require.

Borders and Shading
Usually, a border is applied to a text or page to make sure that those elements stand out in your document. Similarly, you can add borders and shades to a table or a particular cell in a table to make it look unique.

Quickly customize your table border from the Table Options panel.
To apply borders and shades to your table,
- Select the existing table or create a new table from the Insert Panel.
- Click the gear shaped
icon near the inserted table to open the Table Options panel.

- In the Table options panel, under the Borders and Shadings header, you will find options to apply borders and background to your table. You can either apply these settings to the entire table or a particular cell, based on your needs. Refer below to find the border options for tables in Writer.
 |
Select Sides |
Choose all sides or any specific side to apply a border to your table/cell. |
 |
Border Color |
Set a unique color to your table/cell border. |
 |
Border Width |
Click to choose the width of the border. You can set the width up to 10px. |
 |
Border Style |
Apply line style to your table/cell border. |
 |
No Border |
To remove the border applied to the table/cell. |
Table/Cell Background:
To apply a background to your table,
- Select the existing table or create a new table from the Insert Panel.
- Click the gear shaped
icon near the table to open the Table Options panel.

- In the Table options panel, under the Borders and Shadings header, you will find options to background to your table.
- Under the Background Header, click
to apply a solid background color to your table.
- You can also choose an image background for your table/cell. Click
and upload an image from your desktop to add it as your table/cell background.
- Click
to remove the background applied to the table/cell.
You can click the Reset button anytime, to revert all the changes applied to the table/cell.
You can add formulas in the cells of a table and make it work like a spreadsheet. This helps you solve simple mathematical functions by inserting formulas into cells wherever you want.
To add formulas inside the table,
- Click the cell where you want to add the formula.
- Click the Formula icon near the inserted table to open the formula window.

Alternatively, click the gear-shaped
icon near the inserted table to open the Table Options panel. Choose the Formula option at the bottom of the panel.

-
You can enter the formula directly in the formula tab or choose from a list of functions by clicking the drop-down arrow in the Paste Function field. A list of available functions is below:
-
After entering the formula, supply the parameters for the calculation:
- Use cell references in the parentheses in the formula, such as B3 or F7.
- Use a comma to separate references to individual cells.
- To add the values in cells of A1 and G4, the formula would read: =SUM(A1,G4).
- To use all values of cells in a designated range use a colon. The formula would read:
-
=SUM(A1:K1).You can use positional arguments (LEFT, RIGHT, ABOVE, BELOW) with the following functions
- COUNT
- MAX
- MIN
- PRODUCT
- SUM
For example:
=SUM(LEFT) or =SUM(RIGHT) or =SUM(LEFT,ABOVE)
- Choose the Number format and add prefix or suffix, if required. This helps to have better clarity with the results that you got using the formula.
- Once the formula is complete, click OK. Press F9 or refresh the document for results.

- Table formulas work with the Mail Merge feature. You can insert data fields within the cells of a table. When the final document is merged with the appropriate data, the evaluation will be done automatically.
- The formulas in a table are preserved when importing or exporting Microsoft Word documents.
Delete Table
To delete a table,
- Right click on the table. You will see a list of operations that you can do.
- Select Delete Table to delete the entire table.
