Facebook Demo

My TechGenie

4 days 14 hours ago

Do you download data into your spreadsheet? #Excel #WorkSmarter #WorkFaster #ShortCut

My TechGenie

5 days 14 hours ago

What will you do with this shortcut key? #Excel #WorkSmarter #WorkFaster #ShortCut

My TechGenie

6 days 14 hours ago

A shortcut can run a macro to manipulate your data #Excel #WorkSmarter #WorkFaster #ShortCut

My TechGenie

1 week 14 hours ago

What will you do with this shortcut key? #Excel #WorkSmarter #WorkFaster #ShortCut

My TechGenie

1 week 1 day ago

A shortcut could set your printing options. #Excel #WorkSmarter #WorkFaster #ShortCut

My TechGenie

1 week 4 days ago

A shortcut could insert formulas, symbols or apply formatting. #Excel #WorkSmarter #WorkFaster #ShortCut

My TechGenie

1 week 5 days ago

What will you do with this shortcut key? #Excel #WorkSmarter #WorkFaster #ShortCut

My TechGenie

1 week 6 days ago

If you work on a laptop, entering symbols with the numeric keypad might not be available. Having a macro to insert your symbol can be a timesaver! #Excel #WorkSmarter #WorkFaster #ShortCut

My TechGenie

2 weeks 14 hours ago

Excel doesn't have a toggle case shortcut - so I wrote one!
Sub ToggleCase()
Dim Rng As Range
For Each Rng In Selection.Cells
If Rng.HasFormula = False Then
If Rng.Value = StrConv(Rng.Value, vbProperCase) Then
Rng.Value = StrConv(Rng.Value, vbLowerCase)
ElseIf Rng.Value = StrConv(Rng.Value, vbLowerCase) Then
Rng.Value = StrConv(Rng.Value, vbUpperCase)
ElseIf Rng.Value = StrConv(Rng.Value, vbUpperCase) Then
Rng.Value = StrConv(Rng.Value, vbProperCase)
End If
End If
Next Rng
End Sub


#Excel #WorkSmarter #WorkFaster #ShortCut