Assalamu’alaikum,
Praise and gratitude we always pour out to the creator of the universe "Allah SWT” who always gives health, time, and the opportunity to the author to finish this article entitled “How to Fill Serial Data Using AutoFilter in Excel“, so that this article can be in the center of the reader.
Recognize and use “Microsoft Excel application” for calculations and also processing data basic or just knowing method just use it, it can be said that just knowing the outer skin of application Excel the. If studied further, application excel has many features that can used to process data up to results proportional ending.
“Learning Excel is hard, said who?” There are still many people who think that learning Excel is difficult.
Such an assumption only applies to those who are lazy to learn and explore their potential. Why is that? Because, There are already many facilities that can be used to learn Excel, both free and paid.
Especially now Microsoft Office Excel, better known as Microsoft Excel already have the latest version included in the Office package 15.
The Office package issued by the Microsoft company supports adding and changing features that make it easier for users to process data. To process data optimally, an understanding in operating the Excel application is required.
To achieve that, make sure you have the articles on website we (suspended.net) this to the end.
Because, in the website of this article there is a complete guide, tricks and tips, excel formulation and how to use the Excel application that you should know to then apply to your daily work.
How to Fill Serial Data Using AutoFilter in Excel
Have you ever seen workbook users numbering data by selecting values one and two?, then pull it down and form a value of one, two, three, and so on? If ever, that's one of the serial data generation.
Serial data can be interpreted as data that has continuous value. To create serialized data using the autofilter function, you can do the following::
2. Seleksi kedua data tersebut dan letakkan pointer di sudut kanan bawah hingga kursor berubah Becomes tanda tambah berwarna hitam.
3. After the pointer changes to a black plus sign, then click and hold (drag) lalu tarik pointer ke bawah sebanyak sel yang diinginkan dan hasilnya kurang lebih akan terlihat seperti picture di sebelah kanan di bawah.
That's about how to Fill Serial Data Using AutoFilter in Excel. We hope that readers can understand and practice this article properly and correctly.
Thank you
Wassalam.
Similar Posts:
- Automatically Filling Text into Cells – Microsoft Excel
- How to Quickly Create a Decimal Value – Microsoft Excel
- How to make a decimal number with two digits after a comma – Microsoft Excel
- How to Display Data With Accounting Format – Microsoft Excel
- How to Distinguish Positive and Negative Values with Symbols in Excel – Microsoft Excel
- How to Import Data from the Web into Excel – Microsoft Excel
- Excel Formulas Create Pass Captions & Not pass – Blog / items Microsoft Excel Rumus excels
- How to Make Data Validation in Cells – Microsoft Excel
- How to Use Goal Seek – Microsoft Excel
- How to Make Subtotals in Excel – Microsoft Excel
