How to shade every other row in excel 2013?
Hi my name is Roger Ahuja. I'm going to take a couple of minutes and show you how to make data on an excel spreadsheet a little bit easier to read by shading in every other cell as well a couple of other techniques that you can use using tables. So the first thing I'm going to do is highlight the data that I want to use and I'm going to format it as a table. And I can pick different shapes here different styles here rather. I'm going to select this one here. This takes me automatically to the design tab from the home tab. And there's a couple of other choices here that I have. Now if we just take a look at this, we can see that the header is a little darker and that's shown here in the style. I can take the header row and make it completely disappear. I can also add a total row where down here it's added the total. The banded rows are pretty obvious it's just shading every other color. You can also do banded columns here and you can make the first and last column stand out if you want. If you don't need to filter the data using some of the filtering techniques then you can uncheck this. Since I just want to make this a little easier to read and I don't need to filter anything, that's all I'm going to do and also if you need to get back to this, as you're working along, you would simply highlight anywhere in here and go to design. There's also resize table here if you wanted to make this a different size. You can just drag over whatever the new size is and just hit okay and as you can see it does that. And that's it.
Смотрите видео How to shade every other row in excel 2013? онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Roger Ahuja 18 Ноябрь 2013, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 41,91 раз и оно понравилось 5 людям.