![]() ![]() Step 1: Highlight all non-empty rows by selecting them without a header (because we want the header color to be different, It will help recognize the headers). We also can use conditional formatting to shade every alternate row in Excel. Method #2 – Conditional Formatting without Helper Column You can navigate to more designs and create a custom design of your own as well. Step 4: You also have an option to design your table in shades through the Design tab. You can see a table output as shown below, with alternate rows are shaded. Note: Make sure My table has headers option is checked as this option allows Excel to let you know that the first row from your data is a row of headers. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |