How to Create a Fiscal Year Filter

Excel filters data with drop-down boxes.
i Stockbyte/Stockbyte/Getty Images

When you record transactions in a spreadsheet, fiscal years often get separate worksheets or even separate workbooks. If transactions from multiple years enter the same sheet, you can use a fiscal year filter to sort the entries. Filtering by fiscal year enables you to show a single year's transactions at any time. The setup further lets you filter the transactions by other fields, displaying a series of related entries from across several fiscal years.

Step 1

Open the spreadsheet in Microsoft Excel and label the fiscal year column "Fiscal Year," if it isn't already labeled as such.

Step 2

Click the upper left cell in the array that you want to filter. Hold down the "Shift" key and click the lower right cell in the array to select the entire range.

Step 3

Click "Home" in the Excel ribbon and then click "Sort & Filter" to open a drop-down menu.

Step 4

Click "Filter" to add filters along the array's top row.

Step 5

Click the cell labeled "Fiscal Year" and click a specific entry in the list to filter by that year.

the nest