Tips on how to set interval stripes in Excel? (Yidianzixun.com).txt

How to set interval stripes in Excel?

Though we usually use office application like word and Excel, you'll find still lots of usages that we do not know. One example is, now I mentioned to every person: How does Excel set the interval stripe show? Soon after reading the renderings, you need to know that this setting interface continues to be somewhat lovely. Let's discover together~

Method/Step

1. Setting the spacing stripes in Excel not simply tends to make the tables much more clear, but also looks basic and professional. When you don’t know how to set them, get the expertise together, it’s usually simple~

Technique A single: Use Format Fill

We set the shading of the 1st row from the table. If you'd like the color style, you'll be able to decide on what you want. Right here is random green, then the second column just isn't set, then pick the very first and second rows, drag down with all the fill deal with You could accomplish the effect on the above picture.

This approach of format filling is more appropriate for a tiny variety of tables. If there are several, it will be additional troublesome and time-consuming. At the very same time, please note that there is a defect that when we delete one of many rows, it can grow to be the following picture. Stick to the adjustments because the format is currently set.

Process 2: Use conditional format

Open the interface shown inside the figure, and after that click Start out. The conditional format is generally within the upper toolbar. In case your version is distinct, you are able to obtain it.

Then click how to recover photos from formatted hard drive inside the earlier step, the window beneath will pop up, select 'use formula to establish the cell', enter the formula there: =mod(row,two), (making use of this approach, you'll be able to also set the highlighting every three rows Display a line of effects like this.)

Then, within recover photos from hard drive , click the 'Format' button within the pop-up window, then only set the stripe format you wish, you'll be able to set the effect you would like.

Click OK and return, you'll discover that the spacing stripes effect has been set. The table created by this strategy, even if you delete the middle row, will generally keep the spacing stripe style, along with the method 1 isn't attainable but fairly uncomplicated.

The above may be the introduction of the best way to set the show impact of interval stripes in Excel. The operation is quite basic. Have you learned? I hope you like it!

(This short article is from the World wide web and will not represent a point of view of facts)