Get the free Series and Custom Lists (Level 3)

Drag the fill handle down to include cell A15 You should find that the number has been copied down the column - the range A1 to A15 contains identical values. Whenever you use the fill handle the Auto Fill Options button appears as a button attached to the fill handle. Type any number eg 33 into cell A1 and press Ctrl Enter to stay in cell A1 2. Using the mouse point to the fill handle the small black spot at the bottom right of the cell the pointer should change shape to a plain black cross...

How to fill out series and custom lists

How to fill out series and custom lists

1. To fill out a series list, follow these steps:
2. Select the first cell in the series list.
3. Enter the first value of the series.
4. Select the cell with the first value and the cell below it, then drag the fill handle down to fill the series.
5. Release the mouse button to complete the series.
6. The series list is now filled out.
8. To fill out a custom list, follow these steps:
9. Go to the 'File' tab and click on 'Options'.
10. In the 'Excel Options' dialog box, click on 'Advanced'.
11. Scroll down to the 'General' section and click on 'Edit Custom Lists'.
12. In the 'Custom Lists' dialog box, select the 'Import' button.
13. Browse for the file that contains the custom list and click on 'Open'.
14. The custom list will be imported.
15. Click 'OK' to close the dialog boxes.
16. You can now fill out cells using the custom list.

Who needs series and custom lists?

1. Series and custom lists are beneficial for individuals or businesses that require repetitive data entry or want to streamline their data input process.
2. Here are some situations where series and custom lists can be useful:
3. - Sales representatives who need to enter a series of dates or numbers in their sales reports.
4. - Data analysts who frequently input a specific set of values or codes.
5. - Project managers who want to create a custom list for task statuses or project phases.
6. - Accountants who need to fill out financial statements with recurring data.
7. By using series and custom lists, these individuals or businesses can save time and minimize the chances of errors during data entry.

For pdfFiller’s FAQs

How can I get series and custom lists?

The premium subscription for pdfFiller provides you with access to an extensive library of fillable forms (over 25M fillable templates) that you can download, fill out, print, and sign. You won’t have any trouble finding state-specific series and custom lists and other forms in the library. Find the template you need and customize it using advanced editing functionalities.

Can I sign the series and custom lists electronically in Chrome?

As a PDF editor and form builder, pdfFiller has a lot of features. It also has a powerful e-signature tool that you can add to your Chrome browser. With our extension, you can type, draw, or take a picture of your signature with your webcam to make your legally-binding eSignature. Choose how you want to sign your series and custom lists and you'll be done in minutes.

How do I edit series and custom lists straight from my smartphone?

You can easily do so with pdfFiller's apps for iOS and Android devices, which can be found at the Apple Store and the Google Play Store, respectively. You can use them to fill out PDFs. We have a website where you can get the app, but you can also get it there. When you install the app, log in, and start editing series and custom lists, you can start right away.