![]() It will appear in the top row under Custom. When you return to the spreadsheet, click on the Format as Table drop-down in the Styles group again and select the new customized style that you just created. Select Second Row Stripe as the Table Element. In this example, we have selected a pink. Click on the Format button.Ĭlick on the Fill tab and select the color for the shaded rows. When the New Table Quick Style window appears, select First Row Stripe as the Table Element. Then in the Styles group, click on the Format as Table drop-down and select New Table Style at the bottom of the list. Select the Home tab in the toolbar at the top of the screen. In this example, we've selected cells A1:B10. ![]() Question: How can I set up alternating row colors in Microsoft Excel 2010? I want to alternate between 3 shaded rows and 3 white rows.Īnswer: To do this, first highlight the rows that you wish to apply the formatting to.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |