If you don’t like the color you chose initially, it is possible to change it. ![]() How to Edit Your Zebra Stripes’ Excel Style The formatting will also apply to any new rows you add to the table. You should also tick “My table has headers” if it has them.Įxcel should auto color cells in the zebra stripes pattern, with your header rows highlighted in the color of your choice. If needed, you can modify the table range to include more or fewer cells. Press “OK” to the “Create Table” prompt.If you want Excel to keep your formatting before it auto colors cells, you can select “Apply (and Maintain Formatting)” instead. This will remove any current formatting before applying the table style. In the resulting pop-up menu, you want to right-click on a theme option and press “Apply and Clear Formatting”. ![]() Select a color scheme from the dropdown menu.Select the cells and press “Format as Table” in the “Home” tab of the ribbon.To get started shading your worksheet, you’ll want to highlight the rows to format as a table and follow the steps below:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |