How to Add Alternate Row Color in Excel?
It is a very common practice to add shading to alternate rows color in an Excel worksheet to make it less demanding to examine in the data. While it is a by and large basic action to include rows of data physically in somewhat table, it could be a debilitating task in greater ones. A better course is than have the line or segment-substituted automatically in a sheet.
This article tells you the best way to consequently apply to shade to each other row in a worksheet. You can apply the shading by utilizing a straightforward contingent organizing excel formula. Then again, you can apply a predefined Excel table style to your information.
#1 – Add Excel Alternate Row Colors by using Table Style
The quickest and most straightforward approach to apply row shading in Excel is by utilizing predefined Excel table styles.
- Select the data or range where you want to add the color in a row.
- Click to the Insert tab on the Excel ribbon and click Table to choose the function.
- When you click on the table, the dialogue box will appear to select the range.
- Click Ok.
- Now you will get the table with alternate row color in excel as shown below:
- If you don’t want the table with rows, you’d preferably have alternate column shading just, without the table usefulness, you can undoubtedly change over the table back to a standard range. To do this, select any cell inside your table, right click and choose Convert to Range from the setting menu.
#2 – How to Choose Your own Color of Row Stripes?
- Select the table or data, go to the design tab:
- Go to Table style and choose the color of your table which is required and choose by you:
#3 – Delete the Alternate Rows Shading in Excel
If you don’t want to have the shading banding or banded column in your Excel table, you can remove them instantly in one click. You need to select any cell or the whole data in your table, go to the Design tab and select the banded column in table style options and uncheck the Banded rows choice from the option as seen in below screenshot.
#4 – Highlight Alternate Row Color using Conditional Formatting in Excel
- Select the data or range in excel sheet.
- Go to the home tab, and style group and click on conditional formatting in the Excel ribbon.
- Choose a new rule from the drop-down list:
- In the New Formatting Rule dialogue box, choose the option in the bottom of the dialogue box Use formula to determine which cells to format and enter this formula in a tab to get the result =MOD(ROW(),2)=0
- Just click the Format button in the right-hand side and click on switch to the fill tab and choose the background color which you want to use or required for the banded rows in the excel sheet.
- In the dialogue box, as shown above, the color which you have selected will appear under the Sample at the bottom of the dialogue box. If you are satisfied with the color, click OK to choose the same color which showing in a sample.
- Once you click OK, it will carry back you to the New Formatting Rule window in excel sheet, and when you click OK again to apply the excel color to the alternate row of the certain rows. Click Ok, you will get the alternate row color in excel with yellow color as shown below.
Benefits of using Excel Alternate Row Colors
- To improve the readability in the excel sheet, some users shade every other row in a huge Excel sheet.
- Colors enable you to envision your information all the more adequately by empowering you to perceive gatherings of related data by sight.
- When you use the color in your spreadsheet, this theory makes the difference.
- Adding shading to alternate rows or columns (which is called shading banding) can make the information in your worksheet less demanding to examine.
- If any rows are inserted or deleted from the row shading, it adjusts automatically in order to maintain the pattern in your table.
Things to Remember about Excel Alternate Row Color
- Always use the decent colors while coloring the alternate color, because the bright color is not able to solve your purpose.
- While using the conditional formula, always enter the formula in tab otherwise you will not be able to color the row.
- Use dark colors of text so that you can easily read the data in excel worksheet.
- I want to print your excel sheet make sure that you use a light or decent color shade to highlight the rows so that it is read very easily.
- Try not to use the excess of conditional formatting function in your data because it creates lots of confusion.
This has been a guide to Excel Alternate Row Color. Here we discuss how to Add Color to Alternate Rows by using table style & conditional formatting along with examples and downloadable excel template. You may learn more about excel from the following articles –