Entering Data in Excel

Using a spreadsheet, you will not enter series or repetitive data manually. In this lesson you will learn how to enter, consecutive data and create custom list to automate repeated data entries.

First, we have to show is how you can easily enter a series of numbers, days, months, etc. using click and drag technique.

Entering Numbers

Entering series of numbers in Excel is easy, just enter the first number in the cell where you want to start the series and, on the lower-right corner of the cell you will see a small square called a fill handle.

Use the right button of your mouse and drag the fill handle, you will have to guess where you stop to enter the series of numbers. When you release the right mouse button, a menu appears. Click “Fill Series” and the series of numbers appears in the selected cells.

Entering number in Excel

You can also set the interval values of the number series. To do this, repeat the step above, then instead of selecting Fill Series on the menu, select “Series” then on the popup, enter the interval value in the “Step Value” field and click ok.

Entering Numbers In Excel 2

Entering Days of the Week (with or Without Weekends)

Easily enter the days of the week by simply entering the first value (in this sample, we use Monday you can also use Mon), then drag the fill handle to automatically enter the days.

Entering Weedays

You can also skip the weekends, use right mouse button to drag the fill handle. When release, select “Fill Weekdays” in the popup menu.

Entering Weekdays Only

Entering Months or Dates

Months and Dates can be entered same as the days of the week, a simple drag on the fill handle will automatically entered the months and dates.

Entering Dates

Create Custom List

If you have to enter a set of data repeatedly, it’s better to put that into a list so that everytime you need that set of data you just use the fill handle and Excel can fill out for you. In this example, we will add a group of names so that whenever we need this list of names we just fill the first cell with any name in the list then drag the fill handle.

  1. To add custom list, Click office button if you are using Excel 2007 or File Tab if you’re using Excel 2010, then select options.Create Custom List 1
  2. In the options window, select “Advance” then scroll down to see the “Edit Custom Lists” Button.Custom List 2
  3. In the Custom list window, enter the list of in the list of entries under new list, then click “Add” then ok.Custom Lists

Something to clarify? Write it below

This site uses Akismet to reduce spam. Learn how your comment data is processed.