Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-13-2015, 08:08 AM
billyd1979 billyd1979 is offline Font change changes formatting - please help! Windows 7 64bit Font change changes formatting - please help! Office 2013
Novice
Font change changes formatting - please help!
 
Join Date: Oct 2015
Posts: 1
billyd1979 is on a distinguished road
Default Font change changes formatting - please help!


Does anyone know how to prevent the formatting from changing when I change the font in a document? My organization has changed all offical correspondence from Courier New to Times New Roman and when I try to update a document with the new font, it changes all my formatting. MS Word 2013

Please help!
Reply With Quote
  #2  
Old 10-13-2015, 08:31 AM
macropod's Avatar
macropod macropod is offline Font change changes formatting - please help! Windows 7 64bit Font change changes formatting - please help! Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If you have been using Styles properly, changing from Courier New to Times New Roman will only affect the font, not other character attributes. Of course, being a proportional font, you'll find the page layout with Times New Roman is quite different - most likely resulting in far more content per page.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-13-2015, 08:47 AM
Charles Kenyon Charles Kenyon is offline Font change changes formatting - please help! Windows 8 Font change changes formatting - please help! Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,125
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

It will really mess up a document that is not formatted using Styles, especially one where you press Enter at the end of every line. The reality is that these fonts take up different space on a page. Courier New is a monospaced font; TNR is proportionally spaced.

You may have some work ahead of you. I would recommend that you read this short series of pages before you start. It should take about an hour and will save you weeks of work. Basic Concepts of Microsoft Word - from Shauna Kelly
Reply With Quote
  #4  
Old 11-07-2015, 12:49 PM
Words Words is offline Font change changes formatting - please help! Windows XP Font change changes formatting - please help! Office v. X
Explorer
 
Join Date: Dec 2012
Posts: 13
Words is on a distinguished road
Default Macro for changing font without changing formatting

This works for me and is invaluable. Create a macro thus; mine is named Ar10chg because I use it to change everything to Arial 10. All the font sizes, underscores, bold, italic, and font colors are unchanged, but everything becomes Arial 10. Be sure to create a backup first!

Sub Ar10chg()
'
' Ar10chg Macro
' Macro recorded 11/7/2015 by Administrator

Selection.WholeStory
With Selection.Font
.Name = "Arial"
.Size = 10
End With
End Sub
Reply With Quote
  #5  
Old 11-07-2015, 02:18 PM
macropod's Avatar
macropod macropod is offline Font change changes formatting - please help! Windows 7 64bit Font change changes formatting - please help! Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Words,

As has already been indicated, such changes are far better managed by editing the Styles. Your approach creates maintenance issues and is known to eventually contribute to document corruption.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 11-07-2015, 03:59 PM
Charles Kenyon Charles Kenyon is offline Font change changes formatting - please help! Windows 8 Font change changes formatting - please help! Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,125
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Words, this is what the person is likely already doing, albeit manually rather than with a macro. The problem expressed is that doing this changes page and paragraph formatting. That is a result of formatting not using Styles and the use of manual line breaks or the Enter key to manage spacing. If the space bar is used instead of tabs or tables for horizontal spacing, columns will be all over the place. This use of the wrong tools for spacing text on a page will be highlighted by changing from a monospaced font to a proportionally spaced one.

Simply changing the font of text in a document directly (not through use of styles) is done most simply using Replace rather than using a macro. That can be done without changing font size, bolding, Italics, underlining or other formatting.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Font change changes formatting - please help! Looping Macro to Change Font, Font Size, and Give Heading 1 WH7262 Word VBA 1 08-26-2014 03:46 PM
Formatting font MTWord Word 1 11-03-2013 04:08 PM
if letter change font also change gsrikanth Excel 1 05-15-2012 03:03 AM
Font change changes formatting - please help! Make Font Dropdown Change All Styles' Font trevorhiller Word 1 04-14-2012 02:14 AM
Change font across company Dill Excel 1 11-04-2009 08:21 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:40 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