Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-07-2023, 10:34 AM
nbudd nbudd is offline Different column widths Windows Vista Different column widths Office 2003
Novice
Different column widths
 
Join Date: May 2010
Posts: 3
nbudd is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 01-10-2023, 03:27 PM
spillerbd spillerbd is offline Different column widths Windows 10 Different column widths Office 2021
Competent Performer
 
Join Date: Jan 2016
Posts: 130
spillerbd is on a distinguished road
Default

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.
Reply With Quote
  #3  
Old 01-19-2023, 03:20 PM
Guessed's Avatar
Guessed Guessed is offline Different column widths Windows 10 Different column widths Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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
Reply With Quote
Reply

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
Different column widths VBA code to fix column widths molesy Excel 3 09-16-2013 12:51 PM
Different column widths Altering Column Widths on Two Col Page abrogard Word 2 12-30-2010 06:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft