Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to change all the words of one type(Gunsuh type)to another
i have a document including cells with Gunsuh font. is it possible to select
all Gunsuh fonted cells and change it to another type |
#2
|
|||
|
|||
how to change all the words of one type(Gunsuh type)to another
Just select everything, Ctrl-A< and change the font in the font dropdown on
the formatting toolbar. -- HTH RP (remove nothere from the email address if mailing direct) "metumevlut" wrote in message ... i have a document including cells with Gunsuh font. is it possible to select all Gunsuh fonted cells and change it to another type |
#3
|
|||
|
|||
how to change all the words of one type(Gunsuh type)to another
xl2002+ gives you the ability to do Edit|Replace based on format.
If you have mixtures of other fonts that shouldn't be changed, then I think you'll have to do it manually or have a macro that loops through each cell changing the font. Kind of like: Option Explicit Sub testme() Dim wks As Worksheet Dim myCell As Range Set wks = ActiveSheet For Each myCell In wks.UsedRange.Cells If myCell.Font.Name = "Gunsuh" Then myCell.Font.Name = "Arial" End If Next myCell End Sub (I don't have Gunsuh on my pc. Make sure you spell it correctly.) If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm metumevlut wrote: i have a document including cells with Gunsuh font. is it possible to select all Gunsuh fonted cells and change it to another type -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can excel give value in words of number entered in another cell? | Excel Worksheet Functions | |||
Formula to change rows a different colour? | Excel Worksheet Functions | |||
Change FORMAT | Excel Discussion (Misc queries) | |||
How do I get the font color to change automatically depending on | Excel Discussion (Misc queries) | |||
How do I link two cells as to allow me to change the value in eit. | Excel Discussion (Misc queries) |