Formatting cells is a time-consuming task in Excel. With the Cell Formatting function in Eagles Tools, you can quickly add, customize, or also clear all borders with just one click. This will save you lots of time and ensure your data looks cleaner and professional. Here’s how each of the features works:
Features of Cell Formatting
1. Adding Outer Thick Borders
1. Adding Outer Thick Borders
This feature adds a thick border around the outside of the selected cells. The default color is Black, but you can choose from 12 colors in the menu:
Red, Black, White, Gray, Blue, Green, Orange, Purple, Cyan, Magenta, Brown, and Light Gray.
How to Use:
- Select the cells for which you want to apply the outer border.
- Click the Black Outer Borders or any other color from the menu in the Eagles Tools ribbon under the Cell Formatting group.
- The outer border will now appear in your chosen color.
Pro Tip: Use this feature to highlight key sections of your data, such as summary tables or important figures.
2. Adding All Borders
The All Borders feature allows you to apply borders to all the edges of the selected cells, creating a grid-like structure. This is a perfect feature for enhancing the readability of tabular data.
You can choose between two styles: Line Borders and Dotted Borders, both available in 12 colors each. By default, the Gray Line Border is in the ribbon, but you can choose any color.
How to Use:
- Select the range of cells for which the line/dotted borders to be applied.
- Click the Gray All Borders button in the Cell Formatting group or any other color from the menu.
- All line/dotted borders will now be applied in your chosen color for selected cells.
Pro Tip: Use line borders for structured data and dotted borders for softer visual separations.
3. Clear Borders
The Clear Borders feature removes all existing borders from the selected cells, restoring them to their original format.
How to Use:
- Select the range of cells for which the borders to be removed.
- Click the Clear Borders button under the Cell Formatting group in the Eagles Tools ribbon.
- All borders will be instantly removed from the selected cells.
Pro Tip: Use this feature to reset your formatting before applying a new style.