When select column label, a new mini toolbar button called Apply User Parameters to is added. Select it will duplicate selected user parameter to other sheets of selected range. And for user parameter with formula, the formula will also apply for all columns in target sheet.