Excel List Management

Excel, Microsoft Office | Comments Off on Excel List Management

What is a List?

A list is a collection of related data. Examples might include your contact list, an inventory, or your price list. Lists are organized in Rows and Columns, with the first row containing labels. The labels identify the value, or data, directly below the columns.

Features of a well designed List include

  • The first row of your list has data labels
  • Data Labels are formatted differently than data
  • At least one blank row or column separating lists
  • You haven’t used blank/empty rows or columns in data
  • The data format is consistent for the entire column

If your list breaks any of the listed features, your list may become corrupt.

Problems You May Have With a Poorly Designed List:

Sorting

  • If there is a blank column in your list, items on the opposite side of the blank column will not sort
  • When column labels aren’t formatted differently than the list, the labels may sort as data in the list

Filtering

  • You won’t be able to filter a sheet has blank rows between topics because the items below the empty (blank) row, are not part of the same list.

As always, we’re available to help you with your individual questions. Use the Contact form (below) or give us a call to get your training scheduled. Diana also trains for Washoe County and UNR Extended Studies.

We also have a few posts about using Excel, including posts on absolute vs relative references, using proper Order of Operations, and grouping dates in PivotTables.