Create A Custom Table Cell Format In Pages On Mac - Apple Support

• Apple
• • Store
  • Mac
  • iPad
  • iPhone
  • Watch
  • Vision
  • AirPods
  • TV & Home
  • Entertainment
  • Accessories
  • Support
• 0+

Pages User Guide for Mac Open Menu Close Menu

• Communities

Pages Search this guide Clear Search Table of Contents

Pages User Guide for Mac

• Welcome
• What’s new
• Pages basics
  • Get started with Pages
  • Word processing or page layout?
  • Intro to images, charts and other objects
  • Create documents and books
    • Create a document
    • Intro to creating a book
    • Use templates
  • Find a document
  • Open or close a document
  • Save and name a document
  • Print a document or envelope
  • Work in Pages
    • Undo or redo changes
    • Use sidebars
    • Quick navigation
    • View formatting symbols
    • View layout markings
    • Rulers
    • Change the document view
    • Touch Bar for Pages
  • Customise Pages
    • Customise the toolbar
    • Set Pages settings
  • Use VoiceOver with Pages
    • Create a document using VoiceOver
    • Use VoiceOver to preview comments and track changes
• Add text
  • Select text
  • Add and replace text
  • Copy and paste text
  • Use mail merge
    • Add, change or delete a merge field
    • Manage sender information
    • Add, change or delete a source file in Pages on Mac
    • Populate and create customised documents
  • Use dictation to enter text
  • Accents, emoji and special characters
  • Enter text in another language
    • Format a document for another language
    • Use phonetic guides
    • Use bidirectional text
    • Use vertical text
  • Add the date and time
  • Add mathematical equations
  • Bookmarks and links
  • Add links
• Format text
  • Change the font or font size
  • Set a default font
  • Bold, italic, underline and strikethrough
  • Change the colour of text
  • Add a shadow or outline to text
  • Change text capitalisation
  • Use paragraph styles
    • Intro to paragraph styles
    • Apply a paragraph style
    • Create, rename or delete a paragraph style
    • Update or revert a paragraph style
    • Use a keyboard shortcut to apply a text style
  • Copy and paste text styles
  • Format characters and punctuation
    • Format fractions automatically
    • Create and use character styles
    • Ligatures
    • Add drop caps
    • Raise and lower characters and text
    • Format Chinese, Japanese or Korean text
  • Add a highlight effect to text
  • Format hyphens, dashes and quotation marks
• Align and space text
  • Set line and paragraph spacing
  • Set paragraph margins
  • Format lists
  • Set tab stops
  • Align and justify text
  • Set pagination and line and page breaks
  • Format columns of text
  • Link text boxes
  • Add borders and rules (lines)
• Format documents
  • Set paper size and orientation
  • Set document margins
  • Set up facing pages
  • Page templates
  • Add and manage pages and sections
    • Add pages
    • Add and format sections
    • Rearrange pages or sections
    • Duplicate pages or sections
    • Delete pages or sections
  • Document parts
    • Table of contents
    • Bibliography
    • Footnotes and endnotes
    • Headers and footers
  • Add page numbers
  • Change the page background
  • Add a border around a page
  • Add watermarks and background objects
  • Create a custom template
• Add images, shapes and media
  • Images
    • Add an image
    • Add an image gallery
    • Edit an image
  • Shapes
    • Add and edit a shape
    • Combine or break apart shapes
    • Draw a shape
    • Save a shape to the shapes library
    • Add and align text inside a shape
  • Add 3D objects
  • Add lines and arrows
  • Animate, share or save drawings
  • Video and audio
    • Add video and audio
    • Record audio
    • Edit video and audio
  • Set movie and image formats
• Position and style objects
  • Position objects on a page
    • Position and align objects
    • Place objects with text
    • Use alignment guides
    • Layer, group and lock objects
  • Change the transparency of an object
  • Fill shapes and text boxes with colour or an image
  • Add a border to an object
  • Add a caption or title
  • Add a reflection or shadow
  • Use object styles
  • Resize, rotate and flip objects
• Add tables
  • Create and style tables
    • Add or delete a table
    • Select tables, cells, rows and columns
    • Add or change table rows and columns
      • Add or remove table rows and columns
      • Move table rows and columns
      • Resize table rows and columns
    • Merge or unmerge table cells
    • Change how a table looks
      • Change the look of table text
      • Show, hide or edit a table title
      • Change table gridlines and colours
      • Use table styles
    • Resize, move or lock a table
  • Add and organise table data
    • Add and edit cell content
    • Work with different types of data
      • Format dates, currency and more
      • Create a custom table cell format
      • Format tables for bidirectional text
    • Highlight cells conditionally
    • Alphabetise or sort table data
  • Add formulas and functions
    • Calculate values using data in table cells
    • Use the Formulas and Functions Help
• Create and modify charts
  • Add or delete a chart
    • Add or delete a chart
    • Change a chart from one type to another
  • Modify chart data
  • Move, resize and rotate a chart
  • Change the look of a chart
    • Change the look of data series
    • Add a legend, gridlines and other markings
    • Change the look of chart text and labels
    • Add a border and background to a chart
    • Use chart styles
• Use writing and editing tools
  • Check spelling
  • Look up words
  • Find and replace text
  • Replace text automatically
  • Show word count and other statistics
  • View annotations
  • Set author name and comment colour
  • Highlight text
  • Add and print comments
  • Track changes
• Share and collaborate
  • Send a document
  • Publish a book to Apple Books
  • Collaborate with others
    • Intro to collaboration
    • Invite others to collaborate
    • Collaborate on a shared document
    • See the latest activity in a shared document
    • Change a shared document’s settings
    • Stop sharing a document
    • Shared folders and collaboration
    • Use Box to collaborate
• Manage and organise documents
  • Use iCloud Drive with Pages
  • Export to Word, PDF or another file format
  • Open an iBooks Author book in Pages
  • Reduce the document file size
  • Save a large document as a package file
  • Restore an earlier version of a document
  • Move a document
  • Delete a document
  • Lock a document
  • Password-protect a document
  • Create and manage custom templates
  • Transfer documents between devices
    • Transfer documents with AirDrop
    • Transfer documents with Handoff
    • Transfer documents with the Finder
• Troubleshooting
  • If you can’t add or delete a page
  • If you can’t remove something from a document
  • If you can’t find a button or control
  • If page formatting keeps changing
• Keyboard shortcuts
  • Keyboard shortcuts
  • Keyboard shortcut symbols
• Copyright

You can create your own cell formats for displaying numbers, text, and date and time values. Your custom formats are saved automatically and listed in the Data Format pop-up menu so you can use them again.

You might need to create a custom text format for a numeral so that you can use it as a text label. For example, if you enter a phone number with a leading 0 (zero), Pages would normally treat it as a number and remove the leading 0 automatically. If you format the phone number as text, that doesn’t happen.

Note: To create a custom format for numerals to be used as text labels, see “Create a custom text format” below.

Create a custom number format

1. Go to the Pages app on your Mac.

2. Open a document with a table, then select the cells or table you want to format.

3. In the Format  sidebar, click the Cell tab.

4. Click the Data Format pop-up menu, then choose Create Custom Format.

5. Type a name for your format, then click the Type pop-up menu and choose Number.

6. Do any of the following to specify the format:

   • Type text in the field: The text you type appears in the cell.

   • Use tokens to define the type of information you will enter in a cell: Drag tokens to the custom format field. For example, if you’re entering phone numbers into a custom format, you can use an integer token with 11 digits.

     You can also drag tokens within the field to rearrange them.

   • Customise a token element: Click the arrow on a token to show formatting options, such as the type of currency symbol or the number of digits to display.

     

   • Specify rules to accommodate multiple conditions: Add up to three rules to change the formatting of a cell based on specific conditions you define.

     In the example below, all positive numbers you enter are displayed as a phone number with the US area code (952). When you type “5555103” in a cell, it’s displayed as “(952) 555-5103”. When you type “0” in a cell, the cell shows “No number on file”.

     

Create a custom date and time format

1. Go to the Pages app on your Mac.

2. Open a document with a table, then select the cells or table you want to format.

3. In the Format  sidebar, click the Cell tab.

4. Click the Data Format pop-up menu, then choose Create Custom Format.

5. Type a name for your format, then click the Type pop-up menu and choose Date & Time.

6. Define your custom format by doing any of the following:

   • Type text in the field: The text you type appears in the cell.

   • Use tokens to represent the type of information you will enter in a cell: Drag tokens to the custom format field. You can also drag tokens within the field to rearrange them.

   • Customise a token element: Click the arrow on a token to show formatting options for the data.

     The example below uses the day of the year token and custom text so that when you type “25/02/2014” in a cell, the cell displays “56 days into the year”.

     

     If you enter a value that contains a hyphen (-) or a slash (/), such as “04/01/2014”, Pages assumes it’s a date and assigns it a date and time format automatically.

Create a custom text format

1. Go to the Pages app on your Mac.

2. Open a document with a table, then select the cells or table you want to format.

3. In the Format  sidebar, click the Cell tab.

4. Click the Data Format pop-up menu, then choose Create Custom Format.

5. Type a name for your format, then click the Type pop-up menu and choose Text.

6. In the text field, type text that you want to appear automatically in each cell that uses this format.

   The blue “text” token that appears by default in the Custom Format field represents the text that you type in the table cell. In the example below, the text “Notify customer:” appears before whatever you type in a cell. If you type “Need to update address”, the cell displays “Notify customer: Need to update address”.

   

Edit or delete a custom cell format

1. Go to the Pages app on your Mac.

2. Open a document with a table, then select the cells or table with the custom cell format you want to edit or delete.

3. In the Format  sidebar, click the Cell tab.

4. Click the Data Format pop-up menu, then choose the custom cell format you want to edit or delete.

5. Click Edit Custom Format, then do one of the following:

   • Edit the cell format: Make your changes, then click OK.

   • Delete the cell format: Click Delete Format.

     Any cells in your table that use the deleted format revert to Automatic formatting.

See alsoFormat dates, currency and more in Pages on Mac