Is it possible to capitalize a excel spreadsheet?

  harrycat 15:41 06 Aug 2010

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


  VoG II 15:53 06 Aug 2010

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 2010

Found the answer. Thanks.

  harrycat 15:54 06 Aug 2010

Thanks VoG. :-)

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

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

5 best 3D model websites

iPhone 8 vs iPhone X

WhatsApp : comment lire vos messages sans que l’expéditeur le sache