Créer un joli TABLEAU dans EXCEL avec BORDURES et FONDS : Cours Office 365

Introduction

This tutorial will guide you through the process of creating visually appealing tables in Microsoft Excel 365 by adding borders and background colors to cells. You will learn how to customize the appearance of your data, making it easier to read and more aesthetically pleasing.

Step 1: Display Borders

To start customizing your table, you need to ensure that borders are visible around your cells.

1. Open your Excel workbook.
2. Select the cells where you want to apply borders.
3. Navigate to the "Home" tab on the ribbon.
4. Locate the "Font" group and find the borders icon (a square with a grid).
5. Click on the borders icon to display the drop-down menu.
6. Choose your desired border style, such as "All Borders" or "Outside Borders".

Practical Tips

• Use "Outside Borders" for a clean outline around your table.
• Experiment with different border styles to find what works best for your data.

Step 2: Customize Border Style, Thickness, and Color

Next, you can personalize the style, thickness, and color of your borders for a more distinctive look.

1. With your cells still selected, click on the borders icon again.

2. Select "More Borders" at the bottom of the drop-down menu.

3. In the "Format Cells" window, you can:

   • Choose the border style (solid, dashed, etc.)
   • Adjust the thickness of the borders
   • Select a color for the borders using the color palette

4. Click "OK" to apply your changes.

Common Pitfalls to Avoid

• Ensure you are selecting the correct cells before applying the borders.
• Don’t choose overly thick borders that can overwhelm your data.

Step 3: Access the Borders Window

For more advanced border settings, you can access the dedicated borders window.

1. Select the cells you want to modify.
2. Right-click and choose "Format Cells".
3. Navigate to the "Border" tab.
4. Here, you can customize all border options, including setting specific borders (top, bottom, left, right) and styles.

Real-World Application

Using different border styles can help emphasize key sections of your data, making your tables more informative.

Step 4: Apply Background Colors

Now, let’s enhance your table further by adding background colors to your cells.

1. Select the cells you want to fill with color.
2. In the "Home" tab, find the "Fill Color" icon (a paint bucket).
3. Click on the fill color icon to open the color palette.
4. Choose your desired background color.

Practical Tips

• Use lighter colors for backgrounds to maintain readability.
• Consider color coding to categorize different data sets visually.

Conclusion

By following these steps, you can create attractive and functional tables in Excel that improve the presentation of your data. Experiment with different border styles and background colors to find the best combination for your needs. Next, consider exploring other Excel features to further enhance your skills, such as conditional formatting or creating charts.