You can use the arrow buttons to scroll through the available table styles or click the More button to view them all. Just select your table or any cell within the table, switch to the Design tab > Table Styles group and select the colors of your liking. If you are not happy with the default blue and white pattern of an Excel table, you have plenty more patterns and colors to choose from. But what if you want a bit more? How to choose your own colors of row stripes Another disadvantage is that if you sort the data, your color bands will travel with the original rows and your nice zebra stripe pattern will get distorted.Īs you can see, converting a range to table is a very easy and quick way of highlighting alternate rows in Excel. After performing the table-to-range transformation, you won't get the automatic color banding for newly added rows. To do this, select any cell within your table, right click and choose Convert to Range from the context menu. If you'd rather have alternate row shading only, without the table functionality, you can easily convert the table back to a usual range. The best thing is that automatic banding will continue as you sort, delete or add new rows to your table. Once you do this, the odd and even rows in your table will get shaded with different colors automatically. For this, simply select your range of cells and press the Ctrl+T keys together. All you need to do is convert a range of cells to table. ![]() ![]() Along with other benefits of tables such as automatic filtering, color banding is applied to rows by default. ![]() The fastest and easiest way to apply row shading in Excel is by using predefined table styles. Highlight every other row in Excel using banded rows If you'd rather not use a sledge-hammer to crack nuts, meaning you don't want to waste your time and creativity on such a trifle as zebra striping Excel tables, consider applying the built-in Excel table styles as a quick alternative. When it comes to shading every other row in Excel, most gurus will immediately point you to conditional formatting, where you will have to invest some time in figuring out an ingenious mix of MOD and ROW functions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |