The comprehensive utilization of bulk solid waste is of great significance to the realization of carbon neutrality and standards. This review represented recent work on the utilization of solid wastes for preparing foamed ceramics by in-situ foaming process. Especifically, solid waste raw materials, foaming agents and additives, preparation process as well as the performance and application of foamed ceramics were discussed. In addition, the interaction between foaming behavior and sintering process was also revealed, the in-situ pore forming sintering mechanism of foamed ceramics was described, and the existing problems and future development direction were summarized to provide a reference for promoting the further comprehensive utilization of solid waste for preparing foamed ceramics.