top of page

Apply formatting and filters in 3 clicks

Writer: Learn2WorkLearn2Work
Do you want to style and color a data table in seconds? Do you want to add filters to a table quickly? Below I show you how to do both in just a few clicks 👇👇👇

1. Select your table data and click Home > Format as Table :

2. Select the color, shade, and other formatting details from the drop-down options. In our case, we'll choose a turquoise color, with a medium shade, a colored header, and striped rows:


3. Confirm that the table data is the selected one and indicate whether your table has headers or not and press OK :


4. Done! Your data table now has the style applied, and you can also use the arrows in the headers to filter and sort your data :


Take advantage of the "Format as Table" command to give your data tables a nice style in just a few seconds. You can always edit the style if you don't like something, but this option is a good place to start.


Learn how to format and style your Excel workbooks, build a dashboard, and other formatting options in the "Excel for Work" Course on Udemy !

Comments


©2025 Learn2Work

bottom of page