Printing Problems

How to Print Only the Spreadsheet in Microsoft Project

Algirdas Jasaitis Oct 9, 2026 869 views

Question details

The user wants to print the schedule table (spreadsheet) in Microsoft Project without including the Gantt chart portion.

How to Print Only the Spreadsheet in Microsoft Project

Product: Microsoft Project
Device & OS: not provided
Scenario: Preparing a project schedule for printing or sharing with stakeholders who only need to see the tabular data.
Observed behavior: By default, Microsoft Project includes both the spreadsheet data and the visual Gantt chart in the print preview.

Before you start

Ensure your project file is saved and that your schedule columns are configured with only the specific data you wish to print.

Solution 1Recommended

Change the View to Task Sheet

This is the cleanest and most reliable method to hide the Gantt chart entirely before printing.

Switching your active view to the Task Sheet removes the graphical timeline interface, leaving only your data columns. This is the optimal way to print raw project data.

Navigate to the Task Ribbon

Open your project file and go to the 'Task' tab located on the top ribbon of the Microsoft Project window.

Open View Options

Locate the 'Gantt Chart' button on the far left side of the ribbon and click the small dropdown arrow below or next to it.

Select Task Sheet

From the list of available views, click on 'Task Sheet'. Your screen will now only display the spreadsheet columns.

Print the Document

Go to File > Print. You will see in the print preview that only the spreadsheet portion is scheduled to be printed.

View Restored Easily: You can easily revert to your original view after printing by returning to the Task ribbon and selecting 'Gantt Chart' from the dropdown menu.

Solution 2

Drag the Divider Line

A quick workaround if you prefer to stay in the Gantt Chart view but temporarily hide the visual chart for printing.

Free Microsoft Office alternative

Manage Your Project Data with WPS Office

While Microsoft Project is a specialized tool, many project schedules, timelines, and task lists can be easily managed and printed using spreadsheets. WPS Office is a free, lightweight alternative to Microsoft Office that offers full compatibility with Excel formats, making it perfect for tracking project data without the complexity of MS Project.

1. Download WPS Office: Visit the official WPS website and install the free office suite on your device.
2. Export Project Data: In Microsoft Project, save your task list as an Excel Workbook (.xlsx) file.
3. Open and Print: Open the exported file in WPS Spreadsheet to easily format, adjust columns, and print your tabular data.

Fully compatible with Microsoft Excel (.xlsx) formats for easy schedule sharing.Lightweight software that runs smoothly on almost any device.Free to use with a familiar, user-friendly interface.Built-in PDF conversion for seamless printing and document sharing.

microsoft office alternative - wps office

Frequently Asked Questions

Can I export my Microsoft Project table to Excel for easier printing?

Yes, you can export your task data by going to File > Save As and choosing Excel Workbook (*.xlsx). This allows you to open, format, and print just the spreadsheet portion using any standard spreadsheet software like WPS Spreadsheet or Microsoft Excel.

Why does my Gantt chart still show up in the print preview?

If you are in the default Gantt Chart view, Microsoft Project will automatically attempt to print the visual timeline alongside your data. Ensure you have switched your active view to the 'Task Sheet' or dragged the vertical divider completely to the right edge before opening the print preview.

How do I select specific columns to print in the Task Sheet view?

You can hide unwanted columns before printing by right-clicking on the specific column header and selecting 'Hide Column'. Only the visible columns currently displayed in your Task Sheet view will be included in the final printout.

Document & File Issues