How Do I Change a Category Name in Excel?

There isn’t quite “a hack” but you’ll need to change the category name in both your Categories sheet and Transactions sheet. The former is easy. For the latter, you could either do a find/replace or your could setup a filter and then drag the change down over all rows using the old category name.