You can insert, delete, and move rows, and you don't have to worry about reapplying formatting. Now when you return to the spreadsheet, the alternating row color will be applied. First, select the range of cells you want to shade. How to Shade Every Other Row in Excel with Conditional Formatting. Here I’ll introduce 2 commonly used methods to make a table like this. ![]() ![]() It can make the data more vibrant and easy to distinguish. ![]() When the Format Cells box pops up, click the Fill tab and then choose the color (or shade of. You must have seen some Excel spreadsheets with alternating colors in rows or columns. The Format as Table window will pop-up for you to confirm the cell range that will be formatted and the option for you to apply the format to the header rows (ie: My table has headers). Without quotation marks, enter the formula MOD (ROW (),2)0 and click the Format button below. Then in the Styles group, click on the Format as Table drop-down and select one of the options. Select the Home tab in the toolbar at the top of the screen. If you wish to set up alternating row colors in Excel, first highlight the cells that you wish to apply the formatting to. Question: How can I set up alternating row colors in Microsoft Excel 2010? I don't want to have to change the row colors every time I insert, delete, or move a row.Īnswer:Special thanks to Leo for bringing this formatting trick to our attention.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |