User Profile
JKPieterse
Silver Contributor
Joined 10 years ago
User Widgets
Recent Discussions
Re: Complex Cell Format, Maybe!!!
If you are fine with a bit of VBA you can make this happen. Right-click the worksheet's tab and choose "View Code". Paste this code in the window that opens: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count = 1 Then TurnIntoSuperScript Target End If End Sub Next, from the menu, choose Insert, Module. Paste in this code: Sub TurnIntoSuperScript(cl As Range) Dim val As Variant Dim pos As Long val = cl.Value pos = InStr(val, "-") If pos > 0 Then With cl.Characters(Start:=1, Length:=pos - 1).Font .Superscript = False End With With cl.Characters(Start:=pos, Length:=Len(val) - pos + 1).Font .Superscript = True End With Else cl.Font.Subscript = False End If End Sub Now try entering a fraction into a cell on the worksheet.Re: find where named range is used/referenced in entire workbook
Perhaps a belated reply, but my Name Manager contains a button to search for where a name has been used. It searches in all of the Excel objects VBA allows us to inspect, so it also picks up things like Data validation rules, conditional formatting and all sorts of other objects that expose formulas or references. https:\\jkp-ads.com\excel-name-manager.aspx There is even a version which also works on Web Excel.Re: How to sort calculated Field names in Pivot tables
BetAfter The question is not about sorting the field on values, it is about sorting the list of fields in the Insert Calculated Field dialog. As far as I know all you can do is sort the source data alphabetically by Field name. Even then, newly added calculated fields always end up at the bottom.
