Is it possible to capitalize a excel spreadsheet?

  harrycat 15:41 06 Aug 10
Locked

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

Thanks

  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.

Surface Pro 5 News - release date, UK price, features, specs

Microsoft Surface Studio hands-on review: the iMac killer is here

Best Mac antivirus 2017