The airborne sound insulation performance of finite sandwich panels is often significantly worsened by resonant transmission components in low and middle frequencies. In this paper, damping contribution of viscoelastic core on sound transmission loss (STL) of finite constrained layer damping (CLD) panels is studied in narrow frequency bands. A fully coupled layer-wise approach is used with a generalized high-order shear deformation hypothesis that accounts for all types of deformations in the core. The influence of several parameters is investigated extensively. Results show that the adverse impact of the first-three odd-odd order modes, namely (1,1), (3,1), and (1,3) modes, as well as some higher-order modes on STL cannot be disregarded. The constrained viscoelastic core plays a crucial role in enhancing, or even eliminating, dips of STL spectrum at resonant frequencies. Additionally, it can considerably counterbalance a relatively broadband reduction of STL caused by the inter-modal coupling in middle frequencies. The damping mechanism can be divided into two aspects: (i) the reduction of modal amplitude by vibration energy dissipation, and (ii) the change of bending modal shapes. CLD treatment is a concise and effective way to achieve stable sound insulation performance.