Beautiful.ai will automatically detect and format the content of your cell. The cell format automates how the content of your cell will be displayed. 

Format Cell

To format your cell, click on the cell and then click on the Cell Format button. Your Table is defaulted to Text and will auto detect what has been inputted into the cell: 

Format Row or Column

To format an entire column or row, click on on the Column or Row Heading. Then, click on the Format button and select your desired format option: 

Or, click on a cell and drag your cursor to highlight the cells you would like to format. Then, click on the Format button and select your desired format option:

Formatting Options 

Whether you're working with text, numbers, currency, percentages, dates, or even icons/images, we’ve got you covered. Easily customize each column to match your data type, ensuring clarity and professionalism with just a few clicks. Turn your tables into polished, impactful visuals—fast and hassle-free!

Text

When your cell is set to text, you will be able to type in any string of characters without any autoformatting.

Text Align: You will also be able to align the text as either Left, Right, or Center. 

Font Size: The default text size will change to be the best fit for your slide. You can change 

You can change the font size on a cell by cell case or by an entire row or column. 

Number

When your cell is set to Number, you can input numeric values with optional decimal precision, tailored to your needs

Decimal: If you type in a number with a decimal point, Beautiful.AI will automatically display all of the decimal places. 

Thousands Separator will display a character (,) between each separator.

Abbreviated Format: This will abbreviate a number in a cell. For example, 4,000 will display as 4K. Or 4,000,000 will display as 4M.

Accounting Style: Accounting format is used for monetary values. This option will align the numbers on the right side of the cell and the currency symbol on the left.

Change In Value: This will display an up/down arrow or +/- symbol before a number value

Currency 

When your cell is set to Currency, you can display numeric values with your preferred currency symbol and decimal precision for a polished, professional look.

Currency Symbol: The default currency is $. To change the currency to something else, click on the format button and select the symbol of your choice in the Currency menu.

Decimal: Beautiful.AI will automatically display all of the decimal places that are entered in a cell. 

Thousands Separator: This will display a character (,) between each separator.

Abbreviated Format: This will abbreviate a number in a cell. For example, 4,000 will display as 4K. Or 4,000,000 will display as 4M.

Accounting Style: Accounting format is used for monetary values. This option will align the numbers on the right side of the cell and the currency symbol on the left.

Change In Value: This will display an up/down arrow or +/- symbol before a number value

Percent 

When your cell is set to Percent, numeric values are automatically formatted with a percentage sign, making calculations and comparisons a breeze.

To display a percentage, click on the cell format button and select Percent from the format list. Values should be typed in using decimal numbers. For example:

7 becomes 700%

.7 becomes 7%

If you would like to display a percentage with a decimal value, type in the  If you type in a value that has a percent symbol, it will round up to a whole number.

Change In Value: This will display an up/down arrow or +/- symbol before a number value

Date

When your cell is set to Date, you can input and display dates in a consistent format, perfect for tracking schedules and timelines.

The default date format is Month Day. To change the date, click on the Date Format button and under Format, select your desired format.

Icon/Image

To add an icon or an image, click on the cell format button. Under Icon, select from the pre-displayed icons or choose from the icon/image chooser.