Frequently Asked Questions

Many of the questions you may have about Gantt Excel can be answered by FAQs.
If you don’t find the answer to your question through the FAQs, please contact us via the form below.

Do you use Excel’s Conditional Formatting in Gantt Chart Excel?

No, conditional formatting (CF) in Excel is buggy and using CF in Gantt Charts is a strict no no!
Conditional formatting is also known to have compatibility issues between different versions of Microsoft Excel.

We learned this the hard way when we used conditional formatting over two years ago just like all other Gantt chart excel templates and we noticed that CF rules weres duplicated unnecessarily and slowing down the Gantt chart calculations. This resulted in a bloated file and the gantt chart was a disaster of sorts.

So we used simple shapes as timeline bars in Gantt Chart Excel with automation driving the in and out points of the gantt chart timeline bars. This results in a lightweight file and works accurately as intended.

Gantt Chart Excel allows you to customize the timeline bars easily and create a project timeline to impress.






What is the Password to Unprotect the Gantt Chart worksheet?

The worksheets are password protected to protect the gantt chart timeline, formatting, form data and formulas.
You can use all the buttons in the Gantt tab and all functionality without unprotecting the sheet.

Gantt Chart Excel Ribbon

Gantt Chart Excel Ribbon

If you have purchased the Pro or Ultimate version and would like to know the password please contact us and
we will provide you with the worksheet password.

How do I copy-paste tasks from another excel sheet or program?

Gantt Chart Excel version 2.49.3 and above allows you to copy-paste tasks from other excel sheets or programs.

We recommend that you first paste tasks as values and then copy over dates.


Copy-paste should be done one column at a time starting with the task column.
Please note WBS is automatically calculated.


Can I pay using a Credit Card/ Debit Card?

Yes, you can pay via Credit Card/ Debit Card.
We have partnered with 2Checkout and PayPal and both of them accept all major credit and debit cards.

I’m using a Mac and I can’t see the Gantt Excel ribbon. How do I enable it?

Gantt Excel Mac Ultimate is compatible with the latest version of Mac 2016. The latest version of Excel 2016 on Mac supports the Gantt Excel ribbon.

Excel 2016 v15.17 for Mac and below does not support custom ribbon menus. You will have to upgrade your Excel 2016 to the latest version.

Excel 2011 for Mac does not support custom ribbon menus. So we have created a main level menu for this version. You can also right-click anywhere in the file to access the menu.

Gantt Chart Excel Mac 2011 Menu

Error while activating Gantt Chart Excel license?

If you get this error while activating your file…

Activation Error
The most typical reason is one or more firewall programs or proxy settings are blocking Gantt Excel access to the Internet.

There are two things you can do to resolve this.

  1. Copy the file to a machine that has complete access to the internet, activate it there, save the file and copy it back to the machine you want to use it on (You can use a USB stick to copy the file or just email it to yourself).
  2. Contact us via this page and we’ll activate it for you. We’ll endeavor to get back to you within a few hours, we are usually much quicker than that though.
How do I add additional columns to Gantt Chart Excel?

1. Click on the Settings icon in the Gantt tab

Gantt Chart Excel Settings Icon

2. Navigate to the Columns tab.

3. Type the column name in the Text Box next to the “Insert Column” button and then click the Insert Column button

4. This will add a new column into your Gantt Chart. Gantt Chart Excel allows you to add as many as ten custom columns to your Gantt Chart. This will allow you to enter as much information to your Gantt Chart.

Note – Before you add a column please check if you can use one of the existing system columns. You can also unhide and hide columns from this same settings window or delete any user created column.

Contact Us

Your questions and comments are important to us. Get in touch with our team.

Reviews From Around The Globe

People everywhere love Gantt Chart Excel and we thrive off their feedback.

“Just what I was looking for, and such a helpful support team. This gives me the ability to produce professional gantt charts, at a fraction of the cost of other solutions. Well done to the team at GanttExcel.”

Gary Forrest


“The Gantt chart feature in excel is outrageously useful. I’ve worked through a lot of gantt chart tools and Gantt Excel is the best. Thank you for creating this.”

Mark Thompson

Business Analyst

“I took a gamble on Gantt Excel and couldn’t be happier. Not only was the simplicity of the design wonderful to use the layout is easy on the eye too. The customer service provided to me has been one of the best I have ever received from any company out there to help me customise the sheet to better suit my day to day requirements. Thank you Prad and all your staff.”

Peter Hale

“Gantt Excel is very intuitive, fast and offers great features…. My clients find the Gantt Chart easy to read and understandable. Project Managers in my team love this tool. ”


Project Manager

“I put out an inquiry into getting a batch import of tasks into Gantt Excel and the team responded that night with a fully populated output from my data. Made me think that there guys would be able to make customizable gantt charts for other applications given their agile responsiveness.”

“Thank you so much! Your quick reply has guaranteed that we will use your product.
Best wishes!”

Erin C. Blake