#1
|
|||
|
|||
Different column widths
I have a workbook with two different worksheets. In order to get the column widths to look physically alike I have to set them 8.75 (75 pixels) on one and 10 (75 pixels) on the other. I assume this is something to do with the overall font for each individual worksheet because the column header bar has a different appearance.
However, I don't know how to change this font (if indeed that is the problem). The fonts from the Themes menu for both worksheets show Heading: Calibri Light and Body:Calibri. The only other settings that I can think of (in options) would appear to apply to all woksheets, which won't help. Has anyone a suggestion? I have Professional Plus 2019. |
#2
|
|||
|
|||
The fonts listed on the Themes Menu may not show the whole formatting.
If you wish to have the same column widths and/or formatting, you can use the many Paste Special options. Instead of CTRL+V to paste, use ALT, E, S, V and choose the options desired. |
#3
|
||||
|
||||
Each worksheet can be zoomed to different percentages. Check the settings under View > Zoom for both sheets - are they the same percentage?
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to set table column widths exact | hill0093 | Word | 1 | 08-19-2015 03:35 PM |
Splitting one column into two with two different widths | officeboy09 | Excel | 6 | 12-15-2013 09:48 PM |
Adjusting column widths | norwood | Word VBA | 0 | 09-24-2013 06:53 AM |
VBA code to fix column widths | molesy | Excel | 3 | 09-16-2013 12:51 PM |
Altering Column Widths on Two Col Page | abrogard | Word | 2 | 12-30-2010 06:03 AM |