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,975
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



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 08:14 PM.


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