Changing the font case size across a worksheet
Is there an easy way to change the font case from, say a mixture of upper case and lower case to all upper case, across a whole worksheet - (ie like change case in Word)? - without using a macro (not my forte!) Any help would be greatly appreciated. HDV -- HDV ------------------------------------------------------------------------ HDV's Profile: http://www.excelforum.com/member.php...o&userid=26299 View this thread: http://www.excelforum.com/showthread...hreadid=491212 |
Changing the font case size across a worksheet
Assume the text is in A1:H123
Select a range I1:P123......same size as original. In active cell(I1) type =UPPER(A1:H123) hit CTRL + SHIFT + ENTER as it is an array formula. I1:P123 will have the text in Upper case. Copy that range then paste special(in place)ValuesOKEsc. As far as macros go, you should learn how to use them. They are very powerfull and in the changing case opration would be very quick with no formulas or copy/pasting. See David McRitchie's "getting started" site. http://www.mvps.org/dmcritchie/excel/getstarted.htm Gord Dibben Excel MVP On Tue, 6 Dec 2005 15:18:02 -0600, HDV wrote: Is there an easy way to change the font case from, say a mixture of upper case and lower case to all upper case, across a whole worksheet - (ie like change case in Word)? - without using a macro (not my forte!) Any help would be greatly appreciated. HDV |
All times are GMT +1. The time now is 08:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com