Hi. I need a payroll worksheet (Let's call it Ori) copied to another workbook. The column and row width has to be the same for printing purposes. Problem is, column width shrinks when copied over. I've checked page setup and it's the same on both workbooks.
Things I have tried:-
1. Make a Copy > Create a Copy to intended workbook.
- Result: Column width shrinks. (Ori column width A to D: 10.57, 9, 9, 9, 8.14; Copied column width 9.25, 7.88, 7.88, 7.88, 7.13)
2. Copy > Paste special column width
- Result: Remains the same as Step 1.
3. Manually typing in the column width
- Result: Column width auto changes to 10.63, 9, 9, 9, 8.13
4. Save as PDF
- Result: Step 1 is a far cry from Ori; Step 3 is closer to Ori but not exactly the same
5. Replicating a copy by building from scratch
- Result: Forming the same page break will adjust scaling to 94% (Ori scaling is 98%)
Would appreciate any help. ?
Things I have tried:-
1. Make a Copy > Create a Copy to intended workbook.
- Result: Column width shrinks. (Ori column width A to D: 10.57, 9, 9, 9, 8.14; Copied column width 9.25, 7.88, 7.88, 7.88, 7.13)
2. Copy > Paste special column width
- Result: Remains the same as Step 1.
3. Manually typing in the column width
- Result: Column width auto changes to 10.63, 9, 9, 9, 8.13
4. Save as PDF
- Result: Step 1 is a far cry from Ori; Step 3 is closer to Ori but not exactly the same
5. Replicating a copy by building from scratch
- Result: Forming the same page break will adjust scaling to 94% (Ori scaling is 98%)
Would appreciate any help. ?