How to Create a Fiscal Year Filter

Excel filters data with drop-down boxes.

Excel filters data with drop-down boxes.

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.

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

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.

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

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

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


About the Author

Ryan Menezes is a professional writer and blogger. He has a Bachelor of Science in journalism from Boston University and has written for the American Civil Liberties Union, the marketing firm InSegment and the project management service Assembla. He is also a member of Mensa and the American Parliamentary Debate Association.

Photo Credits

  • Stockbyte/Stockbyte/Getty Images