Right-Click the selected area, and select + Insert [X] columns right where [X] is the number of columns you highlighted.

You will get a popup asking if you're sure you want to make changes to this part of the sheet.

Click the checkbox, then click OK

Click the letter header for Column CM to select it.

Right-Click the selected area, then click Copy.

Click the letter header for Column CN to select it; while still holding Left-Click, drag the cursor to the far-right letter header.

You should have all the new blank columns selected plus the one to the right of them.

Right-Click the selected area, then click Paste.

Check the formula bar in the newly pasted cells to ensure the paste was successful.

Your Google Sheets tab capacity has now been increased.

To expand capacity further,
repeat these steps, shifting the column letter targets as needed to add the new columns before the last one.

Expanding the Column Limit

By default, the GHUD Template allows for 497 accessor columns on each tab.
A column counts as an accessor column if its cell in Row 1 is not blank.

If you need to expand this limit first we'll need to determine the number of additional columns we'll need.
Go to the tab with the most columns, and click the Row 1 label to select the whole row.
Check the Count at the bottom right to get the accessor count for this tab.
In this example case, we are using 528 columns; 31 over the default capacity.

(*** Note the following steps need to be repeated on each of the four hidden helper tabs, Return to this point to see the steps again ***)

You can see in Row 2 of the TLAllocate tab how many rows are being applied.
Here we see despite there being 528 columns in the Examples tab, we're only picking up the first 497 of them.

Go to the bottom of the sheet.
A quick way to do this is to select Cell A1, then press Ctrl+DownArrow to have the selection box move down to the lowest cell.
After that, you'll need to scroll down just a bit on the mouse wheel to reveal the "Add 1000 more rows at the bottom" bar.

Change the number from 1000 to the number of extra column capacity you want to add.
In this example case, we need 31 more Columns, but perhaps we'll want more later, so we'll add a flat 50.
After entering the desired number, click Add

After adding rows to the bottom, click the row label for the lowest row (500 in this case) to select the whole row.

Hit Ctrl+C to copy the entire row.

Press Ctrl+Shift+DownArrow to select all cells in the added rows.

Hit Ctrl+V to paste the formulas from row 500 over all of the new rows.
You will likely see some cells will have #NUM! errors.
This is expected, as the other three helper tabs also need to be extended downward.

Go back to the top of the tab. (Ctrl + UpArrow is a fast method, and so is holding PgUp)
You should see now in Row 2 of the column that holds the tab name for the tab that had more than 497 columns,
should now show the actual number of labeled columns it has.
This indicates all of those columns are now counting for the TLAllocate helper tab, a requirement for GHUD.

The second tab is the TLArrays tab.
Expand the bottom rows by the same amount as the prior tab.
Copy the 500th row.
Paste the 500th row over all the new rows.

The third tab is the TLGet tab.
Expand the bottom rows by the same amount as the prior tab.
Copy the 499th row.
Paste the 499th row over all the new rows.

The fourth tab is the _Names tab.
Expand the bottom rows by the same amount as the prior tab.
Copy the 500th row.
Paste the 500th row over all the new rows.

The maximum columns per sheet has now been expanded.

To verify your work, you can navigate back to the TLAllocate tab and go to the bottom rows.
You should now see the #NUM! errors replaced by "[SerializeField] ...".

Though not required, you can now re-hide the helper tabs.
Right click on the TLAllocate tab, then click Hide sheets
Right click on the TLArrays tab, then click Hide sheets
Right click on the TLGet tab, then click Hide sheets
Right click on the _Names tab, then click Hide sheets

Expanding the Row Limit

By default, the GHUD Template allows for 4998 rows among all enum entries.
This limit includes both the NoTab enums on the EnumsLoader Tab,
as well as the enums defined by the Column A of each data tab.

There is also an overhead row per enum plus one extra overhead row that counts against the 4998 row limit. 

This limit can be expanded from the EnumsLoader tab.

Navigate to the bottom of the tab.
One quick way is to select a cell in Column A,
then pres Ctrl + Down Arrow,
then scroll down just a tiny bit with Mousewheel towards yourself.
That should reveal the "Add 1000 more rows at the bottom" bar.

Set the row quantity to however more rows you want to add.
Google sheets has no row limit, but it does have a cell limit of 10,000,000.
For reference, the GHUD Template uses roughly 600,000 cells. 

After deciding on the quantity to add, click Add.

A Heads up! popup will appear.
Click  Don't show this again for 5 minutes,
then click OK

Now that the new rows have been added,
Select the 5000th (formerly last) row by clicking the row labeled 5000.

Copy the row with Ctrl + c.

Select all rows below with Ctrl + Shift + Down Arrow.

Paste over the new rows with Ctrl + v.

If after this you find Google Sheets runs too slowly for you,
Undo the paste,
and copy only cells A5000:M5000,
then select A5001:M#### (with M#### representing the final row and Column M)
And paste there with Ctrl + v instead.
This reduces calculations but keeps a limit to the number of enum entries (rows) in a single tab to at 4998,
but still allows for the collective row limit among all tabs to grow past that number.

The Grand Hawk Union Database is © 2026 Grand Hawk Union. All rights reserved.