Totaling numbers in a gantt chart

Scott_Johnson_AAA 

To manage dragging and dropping blocks in your Gantt chart without disrupting the formulas and conditional formatting, you can use Excel's Table feature.

Here is how you can set it up:

1. Select the range of your Gantt chart data, including the headers.
2. Go to the Insert tab in the Excel ribbon and click on "Table".
3. In the Create Table dialog box, make sure the "My table has headers" option is checked and click OK.

By converting your data range into a table, Excel will automatically apply structured referencing to your data, which makes it easier to work with and maintain formulas.

Now, when you drag and drop the blocks within the table, the formulas and conditional formatting will adjust automatically based on the structured referencing. This allows you to move the blocks without manually rekeying the data or disrupting the calculations.

Additionally, you can use Excel's built-in table features, such as sorting, filtering, and adding new rows, to further manage and manipulate your Gantt chart data easily.

By using this approach, you will have a more dynamic and efficient way of managing your Gantt chart while preserving the formulas and conditional formatting. The text was created with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.