Is it possible to capitalize a excel spreadsheet?

  harrycat 15:41 06 Aug 10

Is it possible to capitalize text in a excel spreadsheet? (Office 2007)


  VoG II 15:53 06 Aug 10

If you mean convert an existing sheet then you'll need VBA.

First click the Office button (top left), click Excel Options, tick Show Developer tab in the ribbon and click OK. Then press ALT + F11 to open the Visual Basic Editor, select Module from the Insert menu and paste into the white space on the right

Sub tocaps()
Dim c As Range
For Each c In ActiveSheet.UsedRange
c.Value = UCase(c.Value)
Next c
End Sub

Press ALT + Q to close the code window, on the Developer tab click Macros, click on tocaps then click the Run button.

  harrycat 15:54 06 Aug 10

Found the answer. Thanks.

  harrycat 15:54 06 Aug 10

Thanks VoG. :-)

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Method Studios' title sequence for BBC series Taboo is truly unsettling

Best Pages for iOS tips | How to use Pages for iPad & iPhone: 6 simple tips to get more out of…