Compare - Formats

<< Click to Display Table of Contents >>

Navigation:  Select > Ribbon >

Compare - Formats

Previous pageReturn to chapter overviewNext page

 

The following cell formats can be compared:

 

Number
It is compared whether the number format of the cells is different.

 

Alignment
Compares the alignment of the cells (left, center, etc.)

 

Font
All the font formattings are compared (font name, size, color, underline, etc.)
 
Border
The cell borders are compared.

 

Fill
The background color of the cells is compared.

 

Protection
The cell protection and visibility of the cell to be compared.

 

 

Proceed as follows to compare the cell formats:

 

1. Click on formats.

 

2. Select "Enable formats". (The format icon changes from gray to black).

 

3. Select all of the formats that you want to compare.

 

 

 

 

In this example, the number formats and font sizes are compared.

format_comparison