Cell Formatting
In Tabulate you have the ability to apply formatting to individual cells, as well as to groups of cells. Formatting can greatly enhance visibility, particularly when working with large worksheets. Modifying default formats allows you to make changes such as altering font color, style, and size, adjusting text alignment within cells, and applying various formatting effects.
Formatting text in a cell
-
To use a different font style, click the arrow next to the default font, Arial, and choose the desired style.
- To increase or decrease the font size, click the arrow next to the default size 12 and pick another text size.
- To incrementally increase or decrease the font size, click on the increase or decrease font buttons (letter A with an increase or decrease sign)
- To increase or decrease the indentation of the text, click increase or decrease indent.
- If you want text or numbers in a cell to appear bold, italic, or have a single underline or strikethrough, select the cell and on the Font ribbon, pick the format you want.
- To change the border style, click borders and select the style required.
- To change the border color, click border color and select the required color.
- To change the background color of the selected text, click Table Background Color and select the required color.
- To change the font color, click Font Color (letter A with a colored underscore) and select the required color.
Positioning text in a cell
To arrange text within a paragraph of text, select the text that you want to align, and on the PARAGRAPH ribbon, pick the alignment option you want.
- You can position the text horizontally within a cell so that it is aligned top, middle, or bottom.
- If it’s a long line of text, you can apply Word Wrap so that all the text is visible.
- You can position the text horizontally within a cell so that it is aligned left, centered, or right.
- To merge or unmerge cells, click on the Merge & Center button and select the required merge format.
Clipboard formatting
- To cut text from a cell or range of cells, select the text and click Cut. The select text will remain in the clipboard.
- To copy text from a cell or range of cells, select the text and click Copy. The select text will remain in the clipboard.
- To paste text from the clipboard, place the cursor where you want the cells to be copied to, then click Paste.
- To copy formatting from one cell to another cell or range of cells.
- Select the cell with the formatting you want to copy.
- Click Format Painter from the CLIPBOARD ribbon.
- Drag to select the cell or range you want to apply the formatting to.
- Release the mouse button and the formatting should now be applied.
Other topics