Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how can i find total width of the columns in a printing area ?
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
in excel just want to add 4 columns and total in next column | Excel Worksheet Functions | |||
Total remaining formula | Excel Worksheet Functions | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Gantt Chart with variable width columns - is this possible? | Charts and Charting in Excel |