Displays line separator Automatically - If you are someone who has a fairly long list of transactions in Excel format, I think it is quite useful as well for you. You have data such as date, amount of purchase, price, and brand of a product.
Indeed, you can also write only casually, but certainly it is less easy to read and confuse you if you want to find the data.
Therefore here I will explains the few ways to make the dividing line automatic for ease of tracking.
In the automatic dividing line, even if you add new data, but with the same category then the line will adjust itself, without having to set it. So how to make the dividing line automatically, here is a tutorial.
Indeed, you can also write only casually, but certainly it is less easy to read and confuse you if you want to find the data.
Therefore here I will explains the few ways to make the dividing line automatic for ease of tracking.
In the automatic dividing line, even if you add new data, but with the same category then the line will adjust itself, without having to set it. So how to make the dividing line automatically, here is a tutorial.
 |
| just for sample ^_^ |
Select the tab Home> Conditional Formatting (located on Grus Styles)> New Rule. It will appear a new dialog box. Select Use a formula to Determine which cells to format and enter the following formula in the box Format values where this formula is true
=$D4<>$D5
|
That's just for sample. you can change it to, for example =$D6<>$D7
Then, in the format, you select a border to your taste, I personally prefer to use only the red border on the bottom, if it is click Ok. |
| Select the border on the Format Cells |
Well, that's the way to make the dividing line automatically in Excel that you can try. Remember to always read the latest updates from my blog
0 komentar:
Posting Komentar