Set font type, size, and color

Format all text in a cell

To apply the formatting to all text in a cell or cell range:

  1. Select a cell, a range of cells or the whole worksheet.
  2. Open the Cell settings panel by
    • tapping the Edit object icon at the top toolbar, or

      Toolbar

    • tapping the Cell option in the pop-up menu.
  3. Use the options at the Cell settings panel:

    Text settings

    • To change the Font Name or Size, tap the Open settings arrow next to the the 11 pt menu item:
      • in the Size section, tap the Minus icon or Plus icon icons on the right to decrease or increase the current font size value, or use the slider.
      • select one of the fonts from the list of the available ones.
    • To change the font typeface, select one of the following options:
      • BoldBold - tap this icon to make the font bold giving it more weight.
      • ItalicItalic - tap this icon to make the font italicized giving it some right side tilt.
      • UnderlineUnderline - tap this icon to make the text underlined with the line going under the letters.
    • To change the color of the characters in the text, tap the Open settings arrow to the right of the Font Color Font Color section and select the necessary color on the palette.
    • To format the cell, tap the Clear formatting Clear icon and choose Everything, or choose Text to format text only.

Format the selected part of text

To apply the formatting to a certain part of text within a cell, select the necessary text passage and use the icons situated at the Text formatting toolbar above the keyboard. You can switch to the alphabet keyboard, tapping the 'ABC' icon on the Open alphabet keyboard switcher located to the right of the sheet navigation panel above the keyboard.

  • Font NameFont Name - tap this icon to select one of the fonts from the list of the available ones.
  • Font SizeFont Size - tap this icon to select among the preset font size values from the list. You can also tap the Minus icon or Plus icon icons in the list to decrease or increase the current value.
  • BoldBold - tap this icon to make the font bold giving it more weight.
  • ItalicItalic - tap this icon to make the font italicized giving it some right side tilt.
  • UnderlineUnderline - tap this icon to make the text underlined with the line going under the letters.
  • Text ColorText Color - tap this icon to change the color of the characters in the text. Select the necessary color on the Text Color tab of the color palettes window.

Power up your iOS

Article with the tag:
Browse all tags