Print Excel Table Rows for a User-Selected Date Range
Question details
Create a print sheet that displays only Excel table rows between user-selected start and finish dates.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user wants to enter a date range and print matching rows from a table.
- Observed behavior
- The print sheet should update to show rows whose dates fall within the selected range.
Check that the source table has a Date column containing real Excel dates rather than text. The FILTER formula requires an Excel version that supports dynamic arrays.
Use FILTER to create a date-range print sheet in Excel
Use this method to update the print sheet automatically when the selected dates or source table rows change.
Select a cell in the source table, open Table Design, and check its Table Name. For the formula below, use tblQ1 and a column named Date, or substitute your own table and column names.
On the print sheet, enter the start and finish dates in two cells. Select the start-date cell and type Start in the Name Box beside the formula bar; name the finish-date cell Finish in the same way.
Copy the source table headings to row 4 of the print sheet. In A5, enter =FILTER(tblQ1,(tblQ1[Date]>=Start)*(tblQ1[Date]<=Finish),"No Rows"). Leave the cells below and to the right clear so the results can spill.
Change the Start and Finish cells to the requested dates, then open File > Print and preview the print sheet before printing.

Filter and print a date range in WPS Spreadsheets
Use the date-column filter in WPS Spreadsheets to display matching rows, then print the filtered sheet.
- 1. Open the workbook: Open the Excel workbook in WPS Spreadsheets and select the sheet containing the table.
- 2. Enable filtering: Select a cell in the table and choose Data > Filter, if filter arrows are not already visible.
- 3. Set the date range: Open the Date column's filter arrow and choose a custom date filter. Set conditions for dates greater than or equal to the start date and less than or equal to the finish date, joined by AND.
- 4. Preview and print: Confirm that the visible rows match the requested range, then choose File > Print to preview and print the sheet.

Frequently Asked Questions
Will the Excel formula include newly added table rows?
Yes. The structured reference tblQ1 expands as rows are added to the table. Add the rows within the Excel table and keep the print sheet's spill area clear.
Why does the print sheet show No Rows?
No source rows match the entered range. Check that Start is not later than Finish and that the Date column and named cells contain real Excel dates.
What does a #SPILL! error mean?
The FILTER results need more empty cells. Clear any content blocking the output below or to the right of A5, then check the formula again.
How do I include entries with times on the finish date?
In the FILTER formula, use tblQ1[Date]<Finish+1 instead of tblQ1[Date]<=Finish. This includes all times before the next day.
Can I use this formula in an older version of Excel?
FILTER requires a version of Excel that supports dynamic arrays. In an older version, use the Date column's filter controls to select the range and print the visible rows instead.




