Data forms add records into a row directly after your last record. If you have blank rows in the middle of your data set, Excel recognizes those gaps as available rows and inserts records from there.

If Excel asks you to expand the range, click Sort to confirm. As you can see in Figure C, you have a reversed data set in a new location, and the original data exists in its original order.

We’ll use an advanced filter on this data set. You already have the source data, so let’s add the criteria and location: Copy the header row to another sheet, twice, as shown in Figure B.

It is important to know what type of data you are working with in order to select the correct forumla. For example, if your data set contains any text values, VARA will interpret text as 0, TRUE ...

How to Put Two Sets of Data on One Graph in Excel. One of the advantages of using Excel as your spreadsheet application is that you can display a simple piece of information just as effectively as ...

Update or filter the data shown in a chart: You can update your chart at any time by modifying the data set from which it is pulled. To illustrate this, go to cell B3 and change the football sales ...

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.