lesnoaddict.blogg.se

You can insert, delete, and move rows, and you don't have to worry about reapplying formatting. Click the OK button to apply the format.Īs you can see, you now have alternating colors - 2 shaded rows followed by 2 white rows. 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). 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 yellow. Click on the Format button.Ĭlick on the Fill tab and select the color for the shaded rows. Installation To install the tweak just follow the instructions in the download file. The idea is to give game a new feel and clearer view. When the New Table Quick Style window appears, select First Row Stripe as the Table Element. ini tweak to disable the game's 'Cell Shading' or 'Black Outlines' feature. 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:B7.

To do this, first highlight the rows that you wish to apply the formatting to. Question: How can I set up alternating row colors in Microsoft Excel 2010? I want to alternate between 2 shaded rows and 2 white rows.Īnswer:Special thanks to Leo for bringing this formatting trick to our attention.