Style Numbers Text For Free

Select the cells you want to format. In the Format sidebar, click the Cell tab. Click the Data Format pop-up menu, then choose Create Custom Format. Type a name for your format, then click the Type pop-up menu and choose Text.

Select the words you want to format. In the Format sidebar, click the Text tab. Click the Style button near the top of the sidebar. In the Font section, click the pop-up menu next to Character Styles, then choose a style.

Replace found text Click. ... Click pop-up menu to the left of the search field, then choose Find & Replace. ... Enter a word or phrase in the first field. ... Enter the replacement word or phrase in the second field. ... Use the buttons at the bottom of the Find panel to review and change the text matches:

If you navigate with arrow keys to a cell, press Option-Return to edit the contents of the cell. The insertion point is placed at the end of the cell's contents. Press Return to accept your edits. Press Esc to exit the editing mode without applying any of your changes.

Create a custom text format Select the cells you want to format. In the Format sidebar, click the Cell tab. Click the Data Format pop-up menu, then select Create Custom Format. Type a name for your format, then click the Type pop-up menu and select Text.

Format columns of text Tap a shape or text box, or select text. Tap. , then tap Text. Tap Columns, then do any of the following: Change the number of columns: Tap. , or tap the number of columns and enter a new value. Set column width: To use the same width for all columns, turn on Equal Column Width.

In the Format sidebar, click the Text tab, then click the Style button near the top of the sidebar. Choose one of the following: A color that coordinates with your template: Click the pop-up menu below the Font section, then choose Text Color. Click the color well, then choose a color.

Edit content: Double-click a cell to make the insertion point appear, then type. To move the insertion point, click where you want it, then type. Replace content: Click the cell, then start typing. The existing content is overwritten.