Create lists of data in Excel spreadsheets

If you have data, use a spreadsheet such as Excel to store it. Excel has built-in tools for tracking data and finding specific information when you need it. With hundreds of columns and thousands of rows, an Excel spreadsheet can contain a huge amount of data. Enter data into the table and in a few steps sort your data and find what you are looking for.

Remark . The instructions in this article apply to Excel 2019, 2016, 2013, 2010; Excel for Office 365, Excel Online, and Excel for Mac.

Content
  1. Enter data in Excel spreadsheets
  2. Excel rows and columns
  3. Create a list in Excel

Enter data in Excel spreadsheets

The main data storage format in Excel is a table. In a table, data is entered in rows. Each line is called a record. After you create a table, use Excel’s data tools to find, sort, and filter records to find specific information.

The first step to creating a table is to enter data. When creating a table, make sure the data is entered correctly. Do not leave empty cells when creating a table, as this may cause problems in the future.

Data errors caused by incorrect data entry are the source of many data management problems. If the data is entered correctly in the beginning, you will get the desired result.

Excel rows and columns

Data series are called records. When entering data, keep the following in mind:

  • Do not leave empty rows in the generated table, even between headers and the first row of data.

  • Each entry contains data for only one specific element.

  • Each item contains all the data about that element. One line cannot contain information about an item.

  • A data table must contain at least two data records before a list can be created.

While the rows in a table are called records, the columns are called fields. Each column needs a header to identify the data it contains. These headers are called field names.

  • The field names are used to ensure that the data is entered in the same order for each record.

  • Enter the data in the column using the same format. If numbers were entered as numbers (for example, 10 or 20), continue. Do not change the part of the path and start entering numbers as words (e.g. ten or twenty). Be consistent.

  • Do not leave empty columns in the table.

  • The table must have at least two columns before the list can be created.

Create a list in Excel

After you enter the data correctly in the table and include the appropriate headings, convert the table to a list.

  1. Select a cell in the table.

  2. Select House > Sort and filter > Filter .

  3. The column headings appear to the right of each heading.

When you select the column heading arrow, the filter menu appears. This menu contains options to sort the list by one of the field names and to search the list for records that match certain criteria.

Leave a Reply

Your email address will not be published.