how can i find total width of the columns in a printing area ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rows and columns on worksheet 1
Setting column widths the same on multiple worksheets 2
How can I expand print area to whole page? 8
Problelm with some sheets not printing the borders (lines). 1
How to split the spreadsheet, not the screen 3
Excel A CountIF question... I think 2
Total width of selected columns? 2
Row Height-Auto Adjust to Content? 5

Back
Top