How to Build a C240 Form in Excel With a Table

Use Excel tables to organize C240 data so it stays aligned when you add rows

A C240 form is a standardized template used in construction and project management to track costs, labor, or materials across multiple line items. Building one in Excel with a table structure keeps your data organized, makes calculations automatic, and prevents the misalignment that happens when you manually insert rows. An Excel table lets you add new entries without breaking formulas or formatting.

The fastest way is to set up your column headers first (the row that names each column), convert that range into a table, then fill in your data. Excel will extend formulas down automatically and keep everything aligned. This takes about five minutes for a basic C240.

Key Takeaways

Start by typing your column headers in the first row, then select the entire range and convert it to a table using the Insert menu.
Excel tables automatically extend formulas down when you add new rows, so you only write the calculation once.
Name your table something clear like "C240Data" so you can reference it in other sheets or reports without confusion.
Use the table's filter buttons to sort or hide rows, and the resize handle in the bottom-right corner to expand the table as you add data.

Set up your column headers and convert to a table

Open a blank Excel sheet and type your column headers in row 1. For a typical C240, you might use columns like Item Number, Description, Unit, Quantity, Unit Cost, and Total Cost. Leave the cells below the headers empty — do not fill in any data yet.

Select the entire header row by clicking the first cell (A1) and dragging to the last column you need, or click A1 and press Ctrl+Shift+End to select to the end of your data. Go to the Insert menu at the top and click Table. Excel will show a dialog asking you to confirm the range. Make sure "My table has headers" is checked, then click OK. Your headers now have filter buttons (small dropdown arrows) and the cells below are formatted as a table.

Add formulas that copy down automatically

Click the first empty cell in the Total Cost column (usually column F, row 2). Type a formula that multiplies Quantity by Unit Cost. In Excel, this looks like =D2*E2 if Quantity is in column D and Unit Cost is in column E. Press Enter.

Excel detects that you are in a table and automatically copies this formula down to every new row you add. If you add ten more items below, the formula extends to all of them without you typing it again. If the formula does not copy automatically, click the cell with the formula, then drag the small square in the bottom-right corner of the cell down to the last row of your data.

Rename your table for clarity

Right-click anywhere inside the table and select Table Design (or Design under Table Tools in the ribbon). Look for the Table Name field on the left side. Replace the default name (usually something like "Table1") with a name like "C240Data" or "ProjectCosts". This makes it easier to reference the table in formulas on other sheets.

A clear name also helps if you share the file with others — they can see at a glance what the table contains. Avoid spaces in the name; use underscores or camelCase instead (C240_Data or C240Data both work).

Use table features to manage your data

The filter buttons in your header row let you sort by any column or hide rows that do not match a condition. Click the dropdown arrow next to "Description" to sort alphabetically, or click the arrow next to "Unit Cost" to show only items above or below a certain price. This is useful when you have dozens of line items and need to find a specific one quickly.

To add more rows, click the last cell in the table and press Tab. Excel creates a new row automatically and applies the same formatting and formulas. You can also right-click inside the table and select Insert to add rows in the middle. The small resize handle in the bottom-right corner of the table lets you drag to expand the table if you need more columns.

Add a total row to sum your costs

Right-click inside the table and select Table Design. Look for a checkbox labeled Total Row and check it. Excel adds a new row at the bottom with the label "Total" in the first column. Click the cell in the Total Cost column of this row, and Excel automatically offers to sum all the values above it. Press Enter to accept.

The total row updates whenever you change a value or add a new item. If you need subtotals by category (for example, total labor costs separate from material costs), you can use the AutoFilter to hide rows and then manually note the subtotals, or create a separate summary table on another sheet that references your main table.

Copy your table to other sheets or formats

If you need to send the C240 to someone else or use it in a different format, select the entire table (click the top-left corner where the row and column headers meet, or press Ctrl+A while inside the table). Copy it with Ctrl+C. You can paste it into another Excel sheet, a Word document, or even email it as a PDF by printing to PDF.

If you paste the table into a new Excel sheet, it remains a table with all the same formulas and formatting. If you paste into Word or PDF, it becomes a static image or text table — the formulas will not work, but the data and layout stay intact.

Frequently Asked Questions

What if I need to insert a row in the middle of my table?

Right-click on the row number where you want to insert a new row and select Insert. Excel adds a blank row and automatically applies the same formulas as the rows around it. The table expands to include the new row.

Can I use a table if my C240 has multiple sections or categories?

Yes. You can create one large table with a Category column, then use the filter buttons to show only one category at a time. Alternatively, create separate tables for each section on the same sheet or on different sheets, and use formulas to sum them together on a summary sheet.

How do I prevent someone from accidentally changing the formulas in my table?

Select the cells with formulas, right-click, and choose Format Cells. Go to the Protection tab and check Locked. Then go to the Review menu and click Protect Sheet. Set a password if you want. Now only the data cells can be edited; the formula cells are locked.

What happens if I delete a row from the table?

Right-click the row number and select Delete. Excel removes the row and the table shrinks. All formulas in the total row or elsewhere that reference the table update automatically. If you delete by mistake, press Ctrl+Z to undo.

Can I export my table to a PDF that looks like the original C240 form?

Yes. Select the table, go to File and click Print. Choose Print to PDF from the printer dropdown. Adjust the page orientation and margins so the table fits on one page, then save. The PDF will show the table exactly as it appears in Excel.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.