Excuse me each great god I want to control the Excel in certain column width, but can adjust the width of any column, can you do it? (for example to ensure A column to the G column total column width can be adjusted on the basis of constant width of any column A to G column), thank you

CodePudding user response:

Can, but you didn't give A specific adjustment algorithm, such as the seven columns, A total of 500 pixels, add 50 pixels when you put A column, the column 6 how to gather together the remaining 50 pixels; When you reduce the width of A column of 50 pixels, extra how this 50 pixels to the remaining six columns,

CodePudding user response:

A great god can further advise?

CodePudding user response:

reference 1st floor Runnerchin response:

can, but you didn't give A specific adjustment algorithm, such as the seven columns, A total of 500 pixels, add 50 pixels when you put A column, the column 6 how to gather together the remaining 50 pixels; When you reduce the width of A column of 50 pixels, the extra how this 50 pixels to the remaining six columns,

A great god can further advise? If this 50 pixels evenly? How to operate in Excel?

CodePudding user response:

VBA

The COLUMNS (I). The width=100