Clear Formatting

Clear Formatting helps you remove cell formatting while keeping the underlying data unchanged. It provides the tools you need to quickly restore cells to their default appearance, making your work more efficient and helping you accomplish tasks with ease. With Clear Formatting, you can clear custom font settings, colors, borders, backgrounds, alignment, and conditional formatting from a single cell, a continuous range, a non-contiguous selection, or an entire sheet, while preserving text, numbers, and formulas. You can also distinguish this action from clearing content, since removing formatting does not delete cell values, and clearing both content and formatting requires a separate clear-all action. Whether you're standardizing worksheet appearance or resetting shared data during collaboration, Clear Formatting helps you stay productive and complete tasks efficiently across different work environments. Choose the documentation below that best matches your needs to learn more.

1:53