In Excel, this is quick and simple to apply by formatting your data as a Table.The row shading is then automatically applied to new rows added to the table.Next, click the Format as Table button within the Home tab and then select the table style you want to use.
![]() This formatting will automatically be applied when new rows are added to the table. You cannot directly edit the existing Excel table styles, but you can create your own or duplicate an existing style and edit that. The More Colors button will provide more specific color options. ![]() On most days, he can be found teaching Excel in a classroom or seminar. Alan gets a buzz from helping people improve their productivity and working lives with Excel. Since we launched in 2006, our articles have been read more than 1 billion times.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |