Way to change font case all at once like in a word processor?

S

StargateFan

I did up some titles in mixed cases then realized that they printed
out better in all upper case. Can we select all and change globally
with a keystroke as in Word, etc.? I ended up doing these all
manually as I couldn't find anything in the pulldowns re this or in
help. Tx.
 
P

pacino

I don't know very much about this place.

I want to have two columns
Susan Shane
Sharon
Ruth Vinnie

And at the bottom I want to have '5' or '6' or whatever.

Thankyou, my sister is getting married!!
 
D

David McRitchie

hi pacino,
Is this an Excel question ? or are you just trying to find out about
newsgroups ? In any case you should start a question as a new thread
not as a reply to a question where that person (stargate) is waiting for an answer to
their question.

If this is an Excel question you might want to take a look at
http://www.mvps.org/dmcritchie/excel/snakecol.htm
but I have no idea what the '5' or '6' at the bottom means.
 
N

Nick Hodge

Not as in Word although you could insert a new row and use the UPPER
function

Equally you could put some code in a module in your personal.xls so it's
available to every workbook so you can then select data and run the relevant
code

Sub ConvertToUpper()
Dim myCell As Range
For Each myCell In Selection
If myCell.HasFormula = False Then
myCell.Value = UCase(myCell.Value)
End If
Next myCell
End Sub

Sub ConvertToLower()
Dim myCell As Range
For Each myCell In Selection
If myCell.HasFormula = False Then
myCell.Value = LCase(myCell.Value)
End If
Next myCell
End Sub


Sub ConvertToProper()
Dim myCell As Range
For Each myCell In Selection
If myCell.HasFormula = False Then
myCell.Value = Application.Proper(myCell.Value)
End If
Next myCell
End Sub


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]
 
D

David McRitchie

My previously suggest macros are the ones you want to use.
Nick's examples require a very careful selection, if you pick entire
columns it may take a long time to run such macros. Particularly
on machines with low memory and slower machines.

I tried to run Nick's convert to upper case on a column
that only had content in the first 300 cells,
after 8 minutes it had not finished and my computer was overheating.

Thought I'd retest, similar poorly designed macros used to take
3 minutes on similar macros that individually process each cell in an
entire column when I had 128MB RAM.
I now have 512MB RAM still running 600mHz

Suggest using the macros suggested in my previous answer in this thread
where you can select an entire column
and run very fast -- well under one second (not actually timed).
http://www.mvps.org/dmcritchie/excel/proper.htm
the code is in
http://www.mvps.org/dmcritchie/excel/code/proper.txt
Be sure to read the web page because it carefully describes
what should be coded in such macros how to identify and avoid
bad examples when you have a choice.
 
S

StargateFan

My previously suggest macros are the ones you want to use.
Nick's examples require a very careful selection, if you pick entire
columns it may take a long time to run such macros. Particularly
on machines with low memory and slower machines.

I tried to run Nick's convert to upper case on a column
that only had content in the first 300 cells,
after 8 minutes it had not finished and my computer was overheating.

Thought I'd retest, similar poorly designed macros used to take
3 minutes on similar macros that individually process each cell in an
entire column when I had 128MB RAM.
I now have 512MB RAM still running 600mHz

Suggest using the macros suggested in my previous answer in this thread
where you can select an entire column
and run very fast -- well under one second (not actually timed).
http://www.mvps.org/dmcritchie/excel/proper.htm
the code is in
http://www.mvps.org/dmcritchie/excel/code/proper.txt
Be sure to read the web page because it carefully describes
what should be coded in such macros how to identify and avoid
bad examples when you have a choice.
Click to expand...

Thank you, everyone, for your suggestions. I like the idea of adding
your macro to the personal.xls. (What would I do without my default
files that I carry around!! <g>).

Cheers. :eek:D
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
Click to expand...
 
Top