Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default how do i turn all letters into capital letters?

In excel, how can i type any letters and it will turn to capital letter
automatically?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default how do i turn all letters into capital letters?

Use the "Caps Lock" key.
--
David Biddulph

"KeithT" wrote in message
...
In excel, how can i type any letters and it will turn to capital letter
automatically?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 21
Default how do i turn all letters into capital letters?

use following function
=upper(cell reference)

"KeithT" wrote:

In excel, how can i type any letters and it will turn to capital letter
automatically?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 903
Default how do i turn all letters into capital letters?

Hi Keith,
Assuming that you mean for some specific columns on a specific
worksheet, you would use an Event macro...

See the event macro under topic
http://www.mvps.org/dmcritchie/excel/proper.htm#upper
you would customize the macro so that it only processes
certain columns. As shown it processes column 6 (Col F) and
will not process row 1. It must be installed as Event macro
by right clicking on the sheet tab then View code.

As for Caps-Lock (see my shortx2k.htm page)
The next best thing to removing the caps lock key, or depression
obstruction is to have it make a noise, and would be what you
would choose for a laptop to avoid physical damage:
Windows Control Panel, accessibility, ToggleKeys option will
provide sound when invoking/revoking Caps Lock, Scroll Lock,
or NumLock keys. (two tones ON/off}
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"KeithT" wrote...
In excel, how can i type any letters and it will turn to capital letter
automatically?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Replacing capital letters jezzica85 Excel Discussion (Misc queries) 5 February 23rd 10 07:49 AM
Excel Capital Letters Humbertt Excel Discussion (Misc queries) 3 May 30th 07 06:08 AM
capital letters to lowercase Xhawk57 Excel Discussion (Misc queries) 5 March 9th 06 04:37 PM
Capital Letters Only Simon Jefford Excel Discussion (Misc queries) 2 February 2nd 06 07:04 PM
Capital Letters Gaute Excel Worksheet Functions 4 March 9th 05 10:55 AM


All times are GMT +1. The time now is 10:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"