Format punctuation

You can automatically convert quotation marks to curly quotation marks and convert double hyphens (--) to dashes (—) in the Substitutions window.

Substitutions window

You can deselect a checkbox to turn off automatic formatting, but existing formatting doesn’t change unless you select the text that contains the formatting you want to change, then click one of the replacement buttons.

Choose a quotation mark style

You can specify a quotation mark style for single and double quotation marks for your spreadsheet. To apply formatting to existing text, select the text first.

  1. Choose Edit > Substitutions > Show Substitutions (from the Edit menu at the top of your computer screen).

  2. In the Substitutions window, select the Smart Quotes checkbox.

  3. Choose a quotation mark style from each of the pop-up menus (for example, “abc”).

  4. Click a button to replace all occurrences of quotation marks in the spreadsheet, or just in the selected text.

Use smart dashes

  1. Choose Edit > Substitutions > Show Substitutions (from the Edit menu at the top of your computer screen).

  2. In the Substitutions window, select the Smart Dashes checkbox.

  3. Click a button to replace all occurrences of dashes in the spreadsheet, or just in the selected text.