View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

In xl2k and higher, you could copy the columns and then:

Edit|pastespecial|columnwidths

In all versions, you can group the sheets and manually adjust the column width.
This will change that column on all the grouped sheets.

EXCELL COLUMN WIDTH wrote:

IF I HAVE DIFFRENT PRINTING SHEET IN A EXCELL WORK BOOK WITH DIFFRENT NUMBER
OF COLUMNS WITH DIFFRENT WIDTH OF THE COLUMNS, AND I NEED TO PRINT THOSE
SHEETS WITH SAME MARGIN SET FOR EACH SHEET. BUT SOME TIME COLUMNS OF THE EACH
SHEET ARE NOT SAME DUE TO SOME REASONS AND PRINTOUT ARE NOT SAME. CAN SOME
BODY TELL HOW TO ADJUST COLUMNS SIZE OF EACH SHEET QUICKLY SO THAT TOTAL
WIDTH OF EACH SHEET ARE SAME


--

Dave Peterson