That means you can plug or unplug some or all of the power cables from your power supply. This way you only have to use the power cables you need and the rest aren't getting in the way. Often the 24 pin main power connector is permanently connected.
Modular power supply means that all the connecting cables are interchangeable or removeable depending on what the hardware requirements are... an example: